Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SqlString error

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-04-08 : 07:38:22
Kam writes "Hi,

I have been working on my final year project for the last 6 Months developing a e-commerce website.

Everytime i try to update the shopping cart it brings up the browser error:

when i check the line where the error has occured it states:

"Con.execute sqlString"

I will really appriciate it if you can help me, i have onyl 1 month to submit this project.


Thank you"

RoyalSher
Yak Posting Veteran

95 Posts

Posted - 2003-04-08 : 07:47:31
Hi,

Can you plz paste the code you are using and the exact error ?



RoyalSher.
*********
The world is the great gymnasium where we come to make ourselves strong.
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-04-08 : 07:53:05
Instead of executing the SQLstring, try printing it to the web page or ALTERT()'ing it so you can see what it is passing. Then examine it to see if it is valid.

The error message might be useful to know as well!

- Jeff
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2003-04-08 : 08:39:50
Que Pasa ALTERT Jeff

Sam

Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-04-08 : 09:10:23
java script .... since the question mentioned a web app. ALERT() is basically the javascript version of the VB msgbox() function.

- Jeff

Edited by - jsmith8858 on 04/08/2003 09:10:45
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2003-04-08 : 09:28:29
My favorite debug output method is

Response.Write VbCrLf & "<!-- " & strDebugData & " -->"

It's strength is that is is not destructive to the HTML validity almost anywhere in HTML body, but requires View, Source to see the result. It can be left in place during production if it doesn't show confidential data.

Sam

Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-04-08 : 09:34:13
oooh ... I hadn't thought of that, I usually just write it to the page ... not bad! I will have to try that.

Thanks!

- Jeff
Go to Top of Page
   

- Advertisement -