Recent content by aarellano

Thank you!!!

so I could do something like this Dim presentuserid presentuserid=rs("userid") if presentuserid=00 then strTableName="WEBSPA.WEEKLYSLS" Session("OwnerID") = Session("_" & strTableName & "_OwnerID") ' to support older events and default values strOriginalTableName="WEB.WEEKLY"...

Hello, I have an asp page that checks the user id, then goes to an acces db to check user credentials, if the user gets authenticated, the user gets redirected to see his data only. This works well. I am trying to ad an admin user. To be able to see all the records here is what my code...

gmmastros!!!!!!!!! I don't care what anybody says!!!! YOU ROCK!!!! I ended up using your code if tbc= "3" then hrs = cDbl(runlab)/1000 elseif tbc="4" then hrs = cDbl(runlab)/10000 elseif tbc="P" then If cDbl(runlab) = 0 Then hrs = 0 Else hrs = 1/cDbl(runlab)...

so in my case it would be if tbc= "'3'" then strhrs = runlab/1000 elseif tbc="'4'" then strhrs = runlab/10000 elseif tbc="'P'" then strhrs = 1/runlab end if

no sorry that did not work my asp page load but I get no data in the hrs field

got it if tbc= "'3'" then hrs = runlab/1000 elseif tbc="'4'" then hrs = runlab/10000 elseif tbc="'P'" then hrs = 1/runlab end if

I hear you, can be a bit confusing at times. Now I get Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch myfile.asp, line 61 lines 56 through 62 56 if tbc= "3" then 57 hrs = runlab/1000 58 elseif tbc="4" then 59 hrs = runlab/10000 60 elseif tbc="P" then 61 hrs =...

thank you that works pretty well the only problem that I have is Error Type: Microsoft VBScript compilation (0x800A03EA) Syntax error /xmldata/empeff.asp, line 58, column 11 elseif tbc=&"P"& then ----------^ I believe is because an alpha character?

Hello, I have a couple of declared variables mo= rs("month") dy= rs("day") dpt= rs("dptno") tbc= rs("tbcod") runlab = rs("runlabor") what I am trying to do now is to declare a new variable with an if statement I have tried hrs = if tbc= 3 then runlab/1000 elseif tbc=4 then runlab/10000...

sweet!!!! Thanks a million gmmastros!!!!!!!!

Hello, I have an asp page that loads dynamic data from one of my servers. In the morning when there is no data in the file when I call my asp page I get the following error Error Type: ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested...

Hello, I am triying to insert a create date in a form when the form is created and a open date when the form was last oppened. I have tried Date() but it changes everytime to the current date. Any suggestions are greatly appreciated!!!!

glad to help!! cheers!!

that is awsome!!! thank you so very, very much!!! I really appreciate the help. I used monthName that did the trick. But in the process I learned functions!!!!! thanks!!!! I am building a dashboard in adobe flex and the most inexpensive fastest way to get the data out of my db to xml was...