How to get a value from database and assign to var
I need to assign a value from database to the variable.
The following is the code i was using for update/delete from database.Can some one tell the changes i need to make for select statment.
objConnection.ConnectionString = "DSN=PostgreSQL ANSI;DATABASE=xxxx;SERVER=xxx;PORT=5432;SSLMODE=pr efer;UID=wand;PWD=13gotoit;A6=;A7=100;A8=8192;B0=2 54;B1=8190;BI=0;C2=dd_;;CX=1b50389"
strQuery = "select status from worker where keyp_workerid = " & k
msgbox objconnection.Execute strQuery
Thanks in advance
Re: How to get a value from database and assign to var
Search the forum and you will get your answer. There are many sample codes for that.