Member Avatar for SheSaidImaPregy

I am trying to alter some SQL to use parameters. I bypassed this earlier as it was just not working but am now heading back to tidy up. For some reason I cannot get this to work, keep in mind I am using Odbc:

SQLString = "SELECT * FROM Stories WHERE StoryID=?"
  'cmdSelectStory.Parameters.Add( "?StoryID", OdbcType.BigInt )
  'cmdSelectStory.Parameters.Add( "?StoryID" ).Value = strStoryID

Anyway I try, I cannot get the parameters to add to the SQL string. In the Odbc database, this column is BigInt(20). I have just been adding it directly into the SQL string, but am now converting that to parameters but cannot figure how. Any help would be appreciated!

  • 1 Contributor
  • 1 Reply
  • 92 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by SheSaidImaPregy
Member Avatar for SheSaidImaPregy

Sorry, after looking at it I realized that I added the parameters before calling it from the command. Therefore, an error arised. fixed.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.