agallant

I have a site that people get emailed registration codes to. When they go to the site there is a box that asks for them to enter there code. If they put in a correct code it pulles there record if they put ion no code or mistype there code the get the following error message You have an error in your SQL syntax near '' at line 1 How do i change the error message? If it could just say some thing like invalid code please use your back button to try agian would be good enoughf. Thanks, AG

does any one know how to Pass multiple URL variables in dreamweaver MX?

I don’t know and professional development company the used Front Page.

Well first of all I have noticed that when you go to www.yoursite.com and see an error page saying that the error is on line 11 and you check line 11 in the code they do not mach up. At lease using DreamWeaver. I would delete the record set and make it new from scratch. I have noticed this will fix most of the bad code problems, also I have noticed with dreamweaver that if you keep on playing with a record set it will mess it up sooner or latter and you will get that message. What are you trying to do? Do you have a simple page with a form submitting to a PHP page to look up a record? Also use the Simple record set view, you do not need the advanced for looking up a simple record by one criteria You will just confuse your self using the advanced. If you are looking up a record by more than one criteria you then you would need to use the advanced and put in a SQL statement. Since I see no SQL error I don’t think that is the case. What are you trying to look up?