Professional Web Applications Themes

SP problem with DATES - Microsoft SQL / MS SQL Server

Could also try cnnGetRows.Execute "update_query " & REPLACE(query,"'", "''") & query_id REPLACE(query, DQ SQ DQ, DQSQSQDQ) meaning DQ=" SQ=' "Tim S" <com> wrote in message news:6%ITa.977$atl2.webusenet.com...  query_id  > > >[/ref]...

  1. #1

    Default Re: SP problem with DATES

    Could also try cnnGetRows.Execute "update_query " & REPLACE(query,"'",
    "''") & query_id
    REPLACE(query, DQ SQ DQ, DQSQSQDQ) meaning DQ=" SQ='

    "Tim S" <com> wrote in message
    news:6%ITa.977$atl2.webusenet.com... 
    query_id 
    >
    >
    >[/ref]



    Tim Guest

  2. #2

    Default Re: SP problem with DATES

    query = request("query")
    query_id = request("query_id")
    query_id = replace(query_id, "'", "''") - assuming this is vbscript

    cnnGetRows.Execute "update_query " & query & query_id


    "trebor" <ca> wrote in message
    news:089901c3518d$a264f5f0$gbl... 


    HSalim Guest

  3. #3

    Default Re: SP problem with DATES

    trebor
    I would prefer to use YYYYMMDD format for all operations with dates.


    "trebor" <ca> wrote in message
    news:089901c3518d$a264f5f0$gbl... 


    Uri Guest

  4. #4

    Default SP problem with DATES

    Thanks for all your efforts above but, alas, none work as
    yet. Thanks again. I'll keep trying...

    PS: Yes it is VBScript.
    Trebor Guest

  5. Moderated Post

    Default Re: SP problem with DATES

    Removed by Administrator
    Trebor Guest
    Moderated Post

  6. Moderated Post

    Default Re: SP problem with DATES

    Removed by Administrator
    HSalim Guest
    Moderated Post

Similar Threads

  1. Between Dates
    By javman in forum Coldfusion - Advanced Techniques
    Replies: 5
    Last Post: June 7th, 02:50 PM
  2. Data Connection Wizard... problem with dates?
    By remecTim in forum Macromedia Flash Data Integration
    Replies: 10
    Last Post: February 27th, 01:32 PM
  3. Problem with insert dates
    By CFcippa in forum Coldfusion - Getting Started
    Replies: 0
    Last Post: June 22nd, 04:07 PM
  4. Problem with dates
    By Stoach in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: March 3rd, 02:21 AM
  5. Problem with insert dates in SQL
    By Oswaldo in forum ASP Database
    Replies: 1
    Last Post: November 21st, 09:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139