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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
