Thanks...most of the strings were being displayed in a msgbox, up until this error. But as I just told Ray, I think I've narrowed it down. I had to resort to going back to Word 2k cos' 2003 started even giving me errors on code I'd commented out!<lol> Sheesh! Give me a break! ;-)
Dian ~ -----Original Message----- From: Shawn K. Hall [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 9:51 PM To: [EMAIL PROTECTED] Subject: RE: [ASP] Help deciphering SQL error Hi Dian, > I'm about to pick this query from hell apart... Are you Response.Write'ing the SQL in your code before you receive the error? There's no way to be sure ASIDE from ensuring that the SQL is actually what you expect it to be, and this is only really possible by "Response.Write sSql" BEFORE you open or execute the SQL. > Error upon SQL query attempt: > "No value given for one or more parameters." It means that you are either using a parameterized query that is missing or misinterpreting a value, or that a SQL parameter is empty, leaving an equals with nothing after it: eg, "WHERE (([something]='whatever') AND ([else]=))" Note that [else] doesn't have a value after the =. Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== "For purposes of action, nothing is more useful than narrowness of thought combined with energy of will." -- Henri Frederic Amiel, Swiss writer --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004 -- This email scanned and certified clean by AVG! Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004 ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
