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

...Source=" & server.MapPath ("\mydb.mdb") set rs = server.CreateObject ("ADODB.Recordset") rs.Open "SELECT * FROM spartan where username='" & Session("Username")& "'", conn, 1 Dim presentuserid presentuserid=rs("userid") strTableName="WEBSPA.WEEKLYSLS" Session("OwnerID") =...

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