Results 1 to 4 of 4

Thread: Error: Unknown Column (Resolved)

Threaded View

  1. Sep 22nd, 2005, 08:02 AM #1
    Paradox
    Paradox is offline

    Thread Starter
    Addicted Member Paradox's Avatar
    Join Date
    Sep 2004
    Location
    Nairobi
    Posts
    189

    Resolved Error: Unknown Column (Resolved)

    I have this problem when trying to execute an sql query
    it returns an error

    Code:
    Error -2147217900 ([MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Unknown column 'CELEPN0200' in 'where clause') in procedure SavePins of Form frmmain        16           Error
    the query is
    Code:
    update pins set scratchcard_value =100 where svalue= CELEPN0200
    My other query is how can i display a message with quotes eg

    msgbox ""Hallo""

    This is because i think the error occurs because i need to enclose the value CELEPN0200 inside quotes

    Thanks
    Last edited by Paradox; Sep 22nd, 2005 at 08:31 AM.
    Peny wise pound Foolish
    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