Ask a Question related to Coldfusion Database Access, Design and Development.
-
jdeline #1
Syntax error in FROM clause
We just installed CFMX on a Windows XP server. A datasource was defined using
the Microsoft Access with Unicode. Certain queries run just fine, while the
one at the bottom of this message produces the following error:
Syntax error in FROM clause.
SQL SELECT * FROM password WHERE uid = 'geoff AND pwd = 'jopevi2k'
DATASOURCE dataSource1
VENDORERRORCODE 3092
SQLSTATE
Any suggestions?
<CFQUERY NAME="getPwd" DATASOURCE="dataSource1" DBTYPE="ODBC">
SELECT * FROM password WHERE uid = '#uid#' AND pwd = '#pwd#'
</CFQUERY>
jdeline Guest
-
I'm getting an Error in my WHERE clause - seems sosimple.
Maybe because I'm new to Cold Fusion, but I'm getting the following error when running this query for a report... "Error Executing Database... -
ERROR 1054 (42S22): Unknown column 'sul._limit' in 'having clause'
mysql> describe s1_user_limits; +--------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default |... -
Simple WHERE clause in CFQUERY Has error executingdatabase query
Hello, I'm sort of new to CF, but have been doing this enough that this is very frustrating! I'm using the standalone version of ColdFusion 6.1 on... -
error : syntax error at or near $1 for over select rows
This is the error i am getting when calling select * from cas_reset_qi_changedate('CAS','2003-02-03' ERROR: syntax error at or near "$1" at... -
syntax error ???
Hi, on login.php , we can see that : (...) $sql = "SELECT Login FROM logins WHERE Login='$fusername'"; $result = mysql_query($sql) or... -
Mountain Lover #2 Re: Syntax error in FROM clause
password is a reserved word, you'll have to escape it by surrounding the
reserved words with brackets e.g. [password]
HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]
Mountain Lover Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
