Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: ado with server side javascript


Message #1 by "shane" <kanji@b...> on Tue, 16 Jan 2001 21:45:51 -0000
dbCommand.ActiveConnection = dbConn;

dbCommand.CommandText = "UPDATE Test_Data SET a = 'test' WHERE id > 50;

dbCommand.Execute(records);



why would this code not return a value for records in javascript, but will

in vbscript?

it will run the sql just fine, but never tells me how many rows were

updated, just returns records = undefined



please email if you have an answer at kanji@b...



Message #2 by Martin McIntyre <MartinM@s...> on Wed, 17 Jan 2001 10:02:34 -0000
Do you have the double quotes missing in your code ? (End of line 2)



-----Original Message-----

From: shane [mailto:kanji@b...]

Sent: 17 January 2001 06:49

To: ASP Web HowTo

Subject: [asp_web_howto] ado with server side javascript





dbCommand.ActiveConnection = dbConn;

dbCommand.CommandText = "UPDATE Test_Data SET a = 'test' WHERE id > 50;

dbCommand.Execute(records);



why would this code not return a value for records in javascript, but will

in vbscript?

it will run the sql just fine, but never tells me how many rows were

updated, just returns records = undefined



please email if you have an answer at kanji@b...



Message #3 by "Drew, Ron" <RDrew@B...> on Wed, 17 Jan 2001 09:03:13 -0500
This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C0808E.3B353CF0

Content-Type: text/plain



Did you type the statement correct or is the double quotes missing after the

50



-----Original Message-----

From: shane [mailto:kanji@b...]

Sent: Wednesday, January 17, 2001 1:49 AM

To: ASP Web HowTo

Subject: [asp_web_howto] ado with server side javascript





dbCommand.ActiveConnection = dbConn;

dbCommand.CommandText = "UPDATE Test_Data SET a = 'test' WHERE id > 50;

dbCommand.Execute(records);



why would this code not return a value for records in javascript, but will

in vbscript?

it will run the sql just fine, but never tells me how many rows were

updated, just returns records = undefined



please email if you have an answer at kanji@b...





---

MaximumASP offers enhanced hosting solutions on the Windows 2000 platform.

Dedicated processor, RAM, and server resources provide dedicated server

performance at virtual server prices. Commercial components provided; custom

components allowed.




$subst('Email.Unsub')





  Return to Index