Results 1 to 3 of 3

Thread: [RESOLVED] SQL Syntax Error

  1. Nov 5th, 2005, 08:40 AM #1
    nvierros
    nvierros is offline

    Thread Starter
    Lively Member nvierros's Avatar
    Join Date
    Nov 2005
    Location
    Melbourne, Australia
    Posts
    110

    Resolved [RESOLVED] SQL Syntax Error

    Hi could someone please tell me what im doing wrong here?

    Set Rs = con.Execute("EXEC fillcalendar @myinput= " & lblMonthInt & " @myyear = " & cboYear)

    Thanks
    Reply With Quote Reply With Quote
  2. Nov 5th, 2005, 08:54 AM #2
    kaihirst
    kaihirst is offline
    Fanatic Member kaihirst's Avatar
    Join Date
    Jul 2005
    Location
    The Resaurant At the End of The Universe
    Posts
    633

    Re: SQL Syntax Error

    Set Rs = con.Execute("EXEC fillcalendar @myinput= " & lblMonthInt & " @myyear = " & cboYear)
    Code:
    Set Rs = con.Execute("EXEC fillcalendar @myinput= '" & lblMonthInt & "' @myyear = '" & cboYear & "';")
    That should do it..

    Hope this helps

    Kai
    As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..

    A few things that make a good Developer a Great One.
    Methodical and a thorough approach to research and design inevitably leads to success.
    Forward thinking is the key to Flow of control.
    Never test in the design environment, always test in real time, you get the REAL results.
    CBSE & OOSE are the same animal, they just require different techniques, and thinking.
    SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
    The key to good design is explicit attention to both detail and response.
    Think Freely out of the "Box" you're in..... You will soar to better heights.

    Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT

    Reply With Quote Reply With Quote
  3. Nov 5th, 2005, 09:20 AM #3
    nvierros
    nvierros is offline

    Thread Starter
    Lively Member nvierros's Avatar
    Join Date
    Nov 2005
    Location
    Melbourne, Australia
    Posts
    110

    Re: SQL Syntax Error

    hmm nah it didnt

    but this did

    VB Code:
    1. Set Rs = con.Execute("EXEC fillcalendar @myinput=" & lblMonthInt & ", @myyear=" & cboYear)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width