Search results for query: *

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...

I also tried mo = if rs("month") = 07 then "July" end if but get the following error Error Type: Microsoft VBScript compilation (0x800A03EA) Syntax error /xmldata/revenue.asp, line 42, column 5 mo = if rs("month") = 07 then "July" end if ----^

I even tried act.WriteLine"<item month=""" & <%if mo = 07 then response.write "July" end if %> & """ value= """ & dddpva & """/>" & vbcrlf but I get the below error Error Type: Microsoft VBScript compilation (0x800A03EA) Syntax error /xmldata/revenue.asp, line 47, column 33...

if I try if mo = 07 then response.write "July" end if the page loads and it gives me Julyrevenue (.xml) has been created on 7/14/2009 11:19:14 AM it adds the July part next to the revenue but the xml looks like this <?xml version="1.0" ?> - <items> <item month="07" value="260119.84" />...

look at the permision for the actual access db right click on the file.mbd and click on properties, click on security assign the permissions there Hope this helps

craigward, I have been looking and asking around and with the help of many I was able to get some code going to be able to build an xml file. I am not a programmer, maybe you can refine the code. In my case the asp page gets the data from an as400 db and outputs to an xml file Hope this is kind...