Forums Register Login

If and else statements in SQL Query

+Pie Number of slices to send: Send
Im getting this error using Aqua Data Studio for below query. Thanks.

>[Error] Script lines: 1-13 -------------------------
ERROR: syntax error at or near "IF"
Line: 1

+Pie Number of slices to send: Send
Melvin,
To the best of my knowledge, SQL doesn't have an if statement. Is that a database specific command/stored procedure? What database are you using?
+Pie Number of slices to send: Send
Im using this statement in XML. For the database i think its DB2.
I knew that guy would be trouble! Thanks tiny ad!
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1835 times.
Similar Threads
Special character handling
Struts 2 --java.lang.NullPointerException
I get error with driver:may have mysql 5.1 and driver is for 5.0?
Displaying a Single Record with a Comma Separated Column from Multiple Records
Inserting a checkbox value into database.
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 18:14:34.