VBScipt help please!

Domo · 29 Apr 2007 at 12:23

I've written some code (with a lot of help!) which passes values from SQL to a perl script as arguments at a command line.

One of the fields in the SQL table is 'read status'.

I'd like to include some code which:

1) detects the read status of 0 (acts as a validation - 0 = records are to be extracted).

2) changes the 0 to a 1 so that specific record is ignored on future sweeps.

Any advice or pointers to online resources would be very welcome.

Cheers,

psyr33n · 29 Apr 2007 at 12:40

What is your SQL and PERL knowledge/experience?

Anyway, some pointers:

1.

Code:

SELECT readstatus FROM table

2.

Code:

UPDATE table SET readstatus = 1

Domo · 29 Apr 2007 at 14:10

Very little experience with perl / VBscript but I do have some experience with t-sql.

Thanks for the help - I'm assuming I can simply embed some t-sql into the vbscript.

Cheers.

pinkaardvark · 30 Apr 2007 at 02:14

Domo said:
Very little experience with perl / VBscript but I do have some experience with t-sql.

Thanks for the help - I'm assuming I can simply embed some t-sql into the vbscript.

Cheers.

You could do, but I'd regard that as a cardinal sin

Just stick it in a stored proc that you call from the VBscript.