[JenMac]

Hi,

I'm having a problem with an UPDATE statement. This works fine:

Expand|Select|Wrap|Line Numbers

1. SQL = "UPDATE Tests SET Face='"&Face&"', Eyes='"&Eyes&"', Glasses ='"&Glasses&"', Beard ='"&Beard&"', Moustache='"&Moustache&"' WHERE ID = 1"

but if I add Hairstyle, Haircol, HairXcoord or HairYcoord, I get an error, e.g. this doesn't work:

Expand|Select|Wrap|Line Numbers

1. SQL = "UPDATE Tests SET Face='"&Face&"', Hairstyle='"&Hairstyle&"', Beard ='"&Beard&"', Moustache='"&Moustache&"' WHERE ID = 1"

The error points to Hairstyle (or Haircol, or whichever one I put in), but I have checked that the field names are correct and that they have values in the Flash file I call the ASP from, so I have no idea what is going wrong. Any suggestions?

Thanks!

[DrBunchman]

Hi JenMac,

You are certain that there are values being passed into the SQL string? Also, do any of the values you are passing in contain single quotes which, as SQL String delimiters, could cause an error?

Dr B

[jhardman]

Usually "Expected End of Statement" means you are missing or have an extra quote mark or you have some other really stupid syntax error. Don't feel ashamed, we've all done this and then felt stupid when we found it.

Jared

[JenMac]

Thanks for your replies.

I decided to change the names I gave the variables in the ASP file - I changed 'Haircol' to 'Col', 'Hairstyle' to 'Style', etc, and it works fine now. I had checked and re-checked the syntax - there were definitely no extra or missing ' and the the values are all numberical, so no ' in them either.

I really don't understand why ASP would have a problem with my variable names, it's not like 'Haircol' is a protected word! If anyone ever comes up with an idea about why it caused a problem, please let me know!

Thanks again for your help.

Jen

[DrBunchman]

Hi Jen,

That is very strange! I would probably still guess that you had some bug in there somewhere because I can't think of any reason why your original variable names wouldn't have worked.

At least it's working now!

Dr B

[omerbutt]

SQL = "UPDATE Tests SET Face='"&Face&"', Hairstyle='"&Hairstyle&"', Beard ='"&Beard&"', Moustache='"&Moustache&"' WHERE ID = 1"

hi firstly the above sql statement are you ,.......or will you be continiously comparing the ID with 1 if so then do write it between the single quotes for example

Expand|Select|Wrap|Line Numbers

1. SQL = "UPDATE Tests SET Face='"&Face&"', Hairstyle='"&Hairstyle&"', Beard ='"&Beard&"', Moustache='"&Moustache&"' WHERE ID = '1' "
2.  

if not then do try the following ,
if it is not going to be a hard coded string then it would be comming from else somewhere in that case type cast it into Clng() and then compare it for example i will assume that the ID is Comming from a prev page

Expand|Select|Wrap|Line Numbers

1. lng_id=Clng(request("db_ID"))
2. SQL = "UPDATE Tests SET Face='"&Face&"', Hairstyle='"&Hairstyle&"', Beard ='"&Beard&"', Moustache='"&Moustache&"' WHERE ID = "&lng_id
3.  

hope that would solve the problem
regards,
omer

[JenMac]

Hi,

The ID is just a test at the moment, you are right - I will be changing this code once I have the database fully set up. At the moment, there is only one record, which has an ID of 1. Thanks for the help with the code for when I do get round to it, though!

Jen

[omerbutt]

Originally Posted by JenMac

Hi,

The ID is just a test at the moment, you are right - I will be changing this code once I have the database fully set up. At the moment, there is only one record, which has an ID of 1. Thanks for the help with the code for when I do get round to it, though!

Jen

yeah sure jen any time
regards,
Omer Aslam