How To Programming Vbscrip Query Sql.

Legacy Poster

• 2012年01月19日 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 ★

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

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • 2012年01月20日 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

請登入寫評論。