Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Query SQL and display msg box

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,49086
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Query SQL and display msg box
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
Query SQL and display msg box - 7/5/2007 6:58:15 AM   
  Abs777

 

Posts: 5
Score: 0
Joined: 7/5/2007
Status: offline 		Is it possible to query sql and display msg box if row contains specific data?  If so could some one please help me out?

Thanks
 
 
Post #: 1
 
RE: Query SQL and display msg box - 7/5/2007 7:28:44 AM   
  dm_4ever


Posts: 2663
Score: 46
Joined: 6/29/2006
From: Orange County, California
Status: offline 		What have you tried so far?

Connecting to DB: http://www.connectionstring.com/
Querying: http://www.w3schools.com/sql/default.asp

_____________________________

dm_4ever

My philosophy: K.I.S.S - Keep It Simple Stupid
Read Me: http://www.visualbasicscript.com/m_24727/tm.htm
Frequently Asked Stuff: http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to Abs777)
 
 
Post #: 2
 
RE: Query SQL and display msg box - 7/6/2007 2:15:00 AM   
  Abs777

 

Posts: 5
Score: 0
Joined: 7/5/2007
Status: offline 		So far I have this to connect

Dim cnt
Set cnt = CreateObject("ADODB.Connection")
cnt.Provider = "SQLOLEDB"
cnt.ConnectionString= "Driver={SQL Server};Server=(local);Database=Apex_DB;UID=sa;PWD="
cnt.Open



I want to display the info in the column in the msgbox.  I have this but it doesn't work.

Dim record
Set recordSet = CreateObject("ADODB.Recordset")
recordSet.Source = Select * from jobs_pending
Msgbox RecordSet.Source

(in reply to dm_4ever)
 
 
Post #: 3
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Query SQL and display msg box Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI