Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sql statement not working
It seems that there is an error in my sql statement, here is the message that ot gave....can someone find the problem... _______________________________________________ This is the result++ UPDATE nouvelle SET date='fdsdf',title='sdfsd',contents='sdfsdf' WHERE nbnews='57' Microsoft OLE DB...- hifive
- Thread
- Replies: 8
- Forum: Microsoft: ASP (Active Server Pages)
-
Not enough parameters
Thank's Mark ! What a great guy you are and what a messy programmer i am, that was an error in my datatbase and a stupid one but thank's to you it's alrigth now...i how you one buddy...- hifive
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Not enough parameters
I got this problem now, the space problem is resolved...i think. This is the code(ASP) : <% Set prodRS = Server.CreateObject( "ADODB.RECORDSET" ) prodRS.ActiveConnection = Con 'THE PROBLEME START HERE sqlString = "SELECT product_id, product_picture, Product, product_briefdesc...- hifive
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
Not enough parameters
I got this problem now, the space problem is resolved...i think. This is the code(ASP) : <% Set prodRS = Server.CreateObject( "ADODB.RECORDSET" ) prodRS.ActiveConnection = Con 'THE PROBLEME START HERE sqlString = "SELECT product_id, product_picture, Product, product_briefdesc...- hifive
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Not enough parameter
I got this problem now, the space problem is resolved...i think. This is the code(ASP) : <% Set prodRS = Server.CreateObject( "ADODB.RECORDSET" ) prodRS.ActiveConnection = Con 'THE PROBLEME START HERE sqlString = "SELECT product_id, product_picture, Product, product_briefdesc...- hifive
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
SQL Statement probleme
Hi tomsark and thank's for your interest i tried this too but that gave me this error message ; ******************************************************** Microsoft OLE DB Provider for ODBC Drivers erreur '80040e10' [Microsoft][Pilote ODBC Microsoft Access] Trop peu de paramètres. 1 attendu...- hifive
- Post #5
- Forum: Microsoft SQL Server: Programming
-
SQL Statement probleme
First thank's for your response! i knew that but how to do it ??? Hifive- hifive
- Post #3
- Forum: Microsoft SQL Server: Programming
-
SQL Statement probleme
Got a problem with this staement: sqlString = "SELECT product_id,product_picture,product,product_briefdesc" &_ "FROM Prod_Products WHERE Product_category='" & cat & "' "&_ "AND product_status=1 " &_ "ORDER BY Product " I...- hifive
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
