Variable Values inside Global Strings

[DeathsBain]

ok... just a pre-note: i am an old unix c/c++ programmer, this visual programming thing is new to me so please accept my apologizes in advance for my ignorance...


that being said, here is my situation --

i am in the process of creating a "Time Keeper & Attendance Program" we call it TKAP :)

i am working on a screen that has a combo-box that has pay-cycle ending dates in it that are populated by a mysql db table. the dates and the combo-box work great. when the data is changed in the combo-box, my code takes and calls a function that goes and needs to look up the status of an end users time that has been submitted... that information is stored in a table called "statusofhours". what i am checking against is to see if they have already submitted their hours for this pay-cycle which would give me a "SH" in a field, not yet submitted - "NS" and already approved -- "AP"

well to make sure that i am checking the correct information i am using a string called "CheckStatusTable" which has the following information in it:

Public CheckStatusTable As String = "select * from `statusofhours` where `username`='" + username + "'"

**explination** the "username" at the end of that statement is a global variable that is set to hold the login name of the user that logged in... that part works fine it does store the name correctly...

the problem that i am running into is that when the code executes, the output of the sql statment is:

select * from `statusofhours` where `username`="

that is all i am getting... so i guess my main question is, how do i get the value that is in the global variable "username" to be part of the sql string???


any and all help would be really appreciated... you can contact me either by:
posting here,
email me (prefered) at: williamgATmalcoproDOTcom,
or IM me (prefered also) at deathsbainATsbcglobalDOTnet (yahoo) or usswilliamgray (AIM)


thanks once again for all your help!!!


Deathsbain -- Have you hugged your undertaker today???

[Killer42]

From the sound of it, you are populating the sql string before the username variable has a value. You need to put together the SELECT statement after you have loaded the username into the global variable - perhaps at the point just before using the sql string. I realise this might seem like extra work, if the username is only set once at login. The important thing is simply that they happen in the correct sequence - setting the sql string just before using it is just sort of the extreme case which would ensure that happened.

Quick question - do you have Option Explicit set? If not, it's always possible you're actually using a non-existent variable somewhere.

Oh, I almost forgot to ask - what version of VB?

[willakawill]

You also have the field username in inverted commas. In sql this indicates a literal string and not a fieldname.

[Killer42]

You also have the field username in inverted commas. In sql this indicates a literal string and not a fieldname.

Actually, I wondered a bit about those, but forgot it when typing my response. (Honest! :))

If we're talking detail, those aren't proper inverted commas, either. They look as though they were converted to "smart quotes" by Word or something.