Ask a Question related to Dreamweaver AppDev, Design and Development.
-
Kory #1
Select Error??
I am getting the following error when loading my page.
Syntax error (missing operator) in query expression '(TrueInsert <
DATEADD('d', -3, NOW())) AND (7Day_Email = 'False')'.
Can anyone tell me what is wrong with this statement?
"SELECT * FROM BuyerReferral WHERE (TrueInsert < DATEADD('d', -3, NOW()))
AND (7Day_Email = 'False')"
Thanks
Kory Guest
-
Please select another location error
"Please select another location to extract the installer to" I get this when trying to upgrade to 7? No matter where i pick, whats up? -
IIF in Select Query Error
Hello, I need to create a query with a date calculation of elapsed minutes. And, I have made this work. Now I find that some of the... -
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... -
SELECT DISTINCT + ORDER BY gives ERROR 145: ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
Following is my stored procedure. If I take the DISTINCT out then everything works fine. BUT I need the distinct because it returns duplicate... -
SELECT DISTINCT + ORDER BY gives ERROR 145: ORDER BY items mustappear in the select list if SELECT DISTINCT is specified.
Dan, You should be able to do this: SELECT Id, FaxID, ReceivedTime, Pages FROM ( SELECT DISTINCT .Id AS Id, -
nisav19 #2 Re: Select Error??
in DATEADD...you have to use DOUBLE QUOTES for d..."d" not 'd' ....thats at least what i found on online references...
nisav19 Guest
-
Kory #3 Re: Select Error??
No, that didn't do it. Just created a different error.
"nisav19" <webforumsuser@macromedia.com> wrote in message
news:d74kip$l8s$1@forums.macromedia.com...> in DATEADD...you have to use DOUBLE QUOTES for d..."d" not 'd' ....thats
> at least what i found on online references...
Kory Guest
-
nisav19 #4 Re: Select Error??
7Day_Email...in your database does it actually have the word FALSE in each field...or does it have 0/1, or is it just a boolean value you are trying to compare
nisav19 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
