How To Programming Vbscrip Query Sql.

Legacy Poster

• January 19, 2012 09:01

Hi
Please provide sample syntax VBScrip for query data from SQL database, I need to know how to sample programming about SELECT data from SQL database.

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • January 20, 2012 02:14
  Syntax error
  
  
  generate SQL
  strCon = "SELECT * FROM " & Tablename & " WHERE " & columnName = '?QueryPrompt1'
  
  How do I coding??

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • January 20, 2012 02:38
  Hi SE'June,
  Query prompt input ('?QueryPrompt1') can be only used in format's database Query or Custom SQL.
  So you cannot use query prompt input within VB Script.
  Could you tell me what you need to do basically?
  
  If you need to retrieve data from database by VBScript rathher than format's datbase connection,
  [url="http://seagullscientific.invisionzone.com/index.php?/topic/201-vbscript-to-populate-a-dropdown-list/page__p__439__hl__select+where__fromsearch__1#entry439"]This post[/url] might helps.
  
  Hope that helps.

  0

Please sign in to leave a comment.