Ask a Question related to Macromedia Dynamic HTML, Design and Development.
-
MalRom #1
SQL wont work
Can anyone suggest why this SQL wont work?
Someone has suggested that I have a few " in the wrong place.
I am missing the basic understanding about variable / string concatenation.
SELECT SupplierName, Location, ShortDescription FROM Query1 WHERE
'TimberSpecies' LIKE '%" & " + Replace(rsSearchResult__MMColParam, "'", "''") +
" & "%' AND 'CategoryTable' LIKE '%" & " + Replace(rsSearchResult__MMColParam2,
"'", "''") + " & "%' AND 'Location' LIKE '%" & " +
Replace(rsSearchResult__MMColParam3, "'", "''") + " & "%' ORDER BY SupplierName"
Thanks
Mally.
MalRom Guest
-
Wont Work
Every time I go to Youtube or photobucket yo watch something, it says you need at least flash player 8 or whatever. And I click the link that takes... -
why wont my output work
<cfquery name="message" datasource="#Request.Site.DataSource#"> SELECT n.message, p.pagename from noticetext n, pages p WHERE... -
button wont work
hey guys im new to actionscript, anyways i have a stop func on the first frame and in that frame i have a button with the cod on(release)... -
Can anyone tell me why this wont work
Dear Stephen on stopMovie repeat with n in the windowlist -- forget n -- use this forget the windowlist end repeat end -
Can anyone tell me why this wont work??
I am trying to check and see if a field is posted or not, if not posted then assign $location which is a session variable to $location_other. If... -
boy mackman #2 Re: SQL wont work
Easiest way to fix this and future SQL errors is to get your page to write the
SQL code to the page, then get that SQL code and execute it using your SQL
server progam.
Depending on what SQL server (mySQL etc..) will depend on how you do this.
Your SQL server program will then tell you where your error is.
Hope this helps
boy mackman 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
