How To Programming Vbscrip Query Sql. Follow

0
Avatar
Legacy Poster

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.

2 comments

0
Avatar
Legacy Poster
Comment actions Permalink

Syntax error


generate SQL
strCon = "SELECT * FROM " & Tablename & " WHERE " & columnName = '?QueryPrompt1'

How do I coding??
0
Avatar
Shotaro Ito
Comment actions Permalink

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.

Please sign in to leave a comment.