Requete bizzare

Forum|Forum|3 years ago
May 31, 2022
3 replies
353 views

Bonjour,

Je programme cette requête souvent avec d'autres fichiers mais là je ne vois pas mon erreur :
Bonjour,

    SELECT *
	FROM Produits
	WHERE Pro_ID=#session.Produit#
</CFQUERY>
		

SQLSTATE 	  07002
EXCEPTIONS 	  <small><i>not set</i></small>
DATASOURCE 	  soliv_solivresdb
VENDORERRORCODE 	-3010
SQL 	  SELECT * FROM Produits WHERE Pro_ID=1139

Merci pour votre aide

Database access

This topic has been closed for replies.

Charlie Arehart

Community Expert

I'd propose other questions and suggestions:

What happens if you leave off the where clause?
Does ANY query from cf to that db work?
What is the db you're call? Sql server? mysql?etc
Does the same query work if run from a query tool for that db?
Is this a newly installed db? Or a newly installed cf?
(I'll note that the code 3010 is often associated with a new sql server install requiring a box reboot before completion. But I'd not really expect it in reply to a query, so that's possibly an unrelated matter.)
What version of cf and the db is it?

/Charlie (troubleshooter, carehart. org)

BKBK

Community Expert

Such strange errors usually arise when you embed <cfquery> within <cfoutput>. Review your code and replace

<cfoutput> 
    <cfquery>
     ...
    <cfquery>
<cfoutput>

with

<cfquery>
 ...
<cfquery>

BKBK

Community Expert

Two more possible causes of the error:

Is Pro_ID a column in the Produits table?
Is Pro_ID a varchar and not a number? If so, change to
```
Pro_ID='#session.Produit#'
```

J

Jean-Marie22691987kfb3Author

Participant

help plz

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded