gue punya masalah nih di Cold Fusion..
gue mo bikin Dynamic Query dengan memanipulasi Query Stringnya..
tapi ada masalah..
Gini nih problemnya.. semoga ada yg bisa bantu..
Kalo mo ngejalanin SQL Query khan gini tag2xnya..
<cfset string="big">
<cfset SearchQuery = "%" & #string# & "&">
<cfquery name="SearchResult" datasource="ti04">
SELECT * FROM anakTI WHERE nama = '#SearchQuery#'
</cfquery>
nah yg diatas itu jalan...
sekarang gue mo bikin gini..(perintah selectnya gue bikin di string sendiri ..)
<cfset string="big">
<cfset SearchQuery = "%" & #string# & "&">
<cfset MyQuery = "SELECT * FROM anakTI WHERE nama = '" & #SearchQuery# & "' ">
<cfquery name="SearchResult" datasource="ti04">
#MyQuery#
</cfquery>
nah kalo yg diatas nggak jalan errornya kayak gini..
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in query expression 'nama
alike "%big%" '.
The error occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (21:1) to (21:52).
seharusnya khan jalan...
kalo gue buat gini juga jalan..
<cfset string="big">
<cfset SearchQuery = "%" & #string# & "&">
<cfset MyQuery = "SELECT * FROM anakTI>
<cfquery name="SearchResult" datasource="ti04">
#MyQuery#
</cfquery>
yg ini querynya nggak pake kondisi where.. tapi jalan..
pliz bilangin gue salahnya dimana.. bingung nih..
thanks
BiG
Layanan Pertukaran Banner - http://www.indobanner.co.id
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
To unsubscribe, e-mail : [EMAIL PROTECTED]
To subscribe, e-mail : [EMAIL PROTECTED]
Netika BerInternet : [EMAIL PROTECTED]
UNLIMITED POP3 Account @ http://www.indoglobal.com
