Post reply

LITERAL STRINGS

  • May 1, 2008 at 8:18 am

    #187206

    WHY DOESNT THIS WORK:

    SELECT C.CUS_PARENT,C.MACNUM,0 AS COUNT

    FROM CUST_FILE C

    WHERE C.CUS_DEACT_DATE = '2008-02-02';

    0 AS COUNT IS A LITERAL STRING I HAVE IN THE SELECT BUT THE QUERY FAILS TO EXECUTE GIVING ME A LITERAL STRING ERROR. I TRIED PUTING SINGLE QUOTES AROUND IT AND EVEN DOUBLE QUOTES BUT IT STILL DOES NOT WORK.

    DOES ANYONE HAVE A SUGGESTION?

    THANKS

  • May 1, 2008 at 8:27 am

    #809581

    are you sure the zero is causing the problem, it's alias? try SELECT 0 as CNT instead of the reserved word COUNT

    also, careful with the datefield...

    it's good practice to use the oracle TO_DATE function:

    .datefield=TO_DATE('04/14/2008',MM/DD/YYYY')

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 1, 2008 at 8:30 am

    #809587

    What is the exact error message you are getting?

    Is this query being run on SQL Server or ORACLE?

    I ran a similar query in the AdventureWorks database on my machine and it did not return an error. If on SQL Server I would recommend against using COUNT as a column name since it is an aggregate function.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • May 1, 2008 at 8:33 am

    #809596

    THE ERROR I'M GETTING IS 'LITERAL DOES NOT MATCH FORMAT STRING' I AM RUNNING THIS ON ORACLE AND I CHANGED THE WORD COUNT TO CNT AND IT STILL DOES NOT WORK.

  • May 1, 2008 at 8:40 am

    #809610

    First, you might want to try asking your Oracle question on an Oracle forum... you'll usually get more correct answers that way... just a thought. 😉

    Second, Oracle requires you to convert your literal date string to a date using TO_DATE like Lowell suggested.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 1, 2008 at 8:47 am

    #809618

    THAT WORKED THANKS

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply