Recent content by aspnetuser

onpnt It was working fine until I changed the hours data type to numeric and the check box fields stayed int is their anything else you could help me with?

I took them off and get : Incorrect syntax near the keyword 'where'.

sql = "update qryEnterHours set Hours = '" & hours & "' where Username = '" & Username & "' and PayDates = '" & PayDates & "'" set rs = DbConn.Execute(sql) set rs = nothing he is where it fails? how do i fix it with cint?

I get the following error message when trying to check a check box that will update a sql field type INT. Error converting data type varchar to numeric. web form hours check box hours is set to numeric. chekc box is set to int. it only fails when i try to check a check box and hit submit...

just to store decimals 4.5 4.25 i tried numberic scale = 2 is that ok

I need to store hours field in sql server 2000. What data type should i use? I need to store values like 4.25 4.50 etc... please advise?

I get the time out message in less than 1 minute using 600 seconds... has to be something else?

IT WORKED! Thanks so much!

He is a piece of code that always use to work. Not it is referenced in the time out. sql = "select count(*) as total" _ & " from Picks, Schedule" _ & " where Username = '" & username & "'" _ & " and Picks.GameID = Schedule.GameID" _ & " and Picks.Pick =...

600 then tried 800 code still fails

I am using the following code to generate links to files i have. ' output the filename and URL Response.Write "<li><a href=""" & strDocsPath & "/" & strFile & """>" & strName & "</a><br>" How can I make this a popup window (new window) when it is clicked?

it still times out :(

I got it to run but it returns 0 everytime. (select count(AKA."Pick") from vw AKA where AKA."Username" = vw."Username" and AKA."Pick" = vw."Result")/ (select count(AKA."Pick") from vw AKA where AKA."Username" = vw."Username") * 100 There is only one view as the datasource.

I don't understand your post? What is vw B?

(select count(AKA."Pick") from P AKA, vw B where AKA."Username" = P."Username" and AKA."Pick" = B."Result")/ (select count(AKA."Pick") from P AKA, vw B where AKA."Username" = P."Username") * 100 invalid object name p