|
I'm getting the following error. I have been commenting lines out and it seems to get through to the end without errors but I can't find my mistake. The code is in a tool.asp page with a lot of other similar functions and subs. Any help is much appreciated
Microsoft VBScript compilation error '800a0400'
Expected statement
/pages/tools.asp, line 636
End Function
'------------------------------------------------------------------------------
Function fnProcessSomePicks(byRef passedCon)
'------------------------------------------------------------------------------
response.write("In fnProcessSomePicks<br>")
Dim objRSPicks
Dim SQLPicks
Dim intPickID
Dim flgProcess
Dim flgProDay
Dim sTeamID
Set objRSPicks = Server.CreateObject("ADODB.Recordset")
SQLPicks = "SELECT " & _
"Picks.PickID, " & _
"Picks.PlayerID, " & _
"Picks.Week, " & _
"Picks.TeamID, " & _
"Picks.plyrGuess, " & _
"Picks.LockPick " & _
"FROM " & _
"Picks " & _
"WHERE " & _
"((Picks.Week)= " & _
CInt(Application("intPoolWeek")) & " );"
Set objRSPicks = passedCon.Execute( SQLPicks )
If NOT objRSPicks.BOF OR NOT objRSPicks.EOF Then
objRSPicks.MoveFirst
End If
Do While Not objRSPicks.EOF
intPickID = 0
'
' flgProcess:
' 0 = already locked - do nothing
' 1 = not locked both team and score exsit
' 2 = not locked team only
' 0 = not locked score only
flgProcess = 0
flagProDay = 0
If NOT objRSPicks.BOF OR NOT objRSPicks.EOF Then
Do While Not objRSPicks.EOF
intPickID = objRSPicks("PickID")
If objRSPicks("LockPick") = True Then
flgProcess = 0
ElseIf Len(objRSPicks("TeamID")) > 0 Then
If (objRSPicks("plyrGuess")) > 0 Then
flgProcess = 1
Else
flgProcess = 2
End If
End If
If flgProcess <> 0 Then
sTeamID = objRSPicks("TeamID")
flgProDay = fnGameDay(passedCon, sTeamID)
If flgProDay = 1 Then
If flgProcess = 1 Then
' Perform Lock action
Else
' Set and perform Lock action
End If
End If
End If
objRSPicks.MoveNext
flgProcess = 0
Loop
End if
CALL subADOClose(objRSPicks)
End Function
Thanks Again Mike
|
|
|
|
|
BustAGutt wrote: Do While Not objRSPicks.EOF
You're missing a matching Loop for this.
Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'
|
|
|
|
|
Is this a moment where you are "willing to admit familiarity with most of the various forms of VB"
Regards,
--Perspx
"The Blue Screen of Death, also known as The Blue Screen of Doom, the "Blue Screen of Fun", "Phatul Exception: The WRECKening" and "Windows Vista", is a multi award-winning game first developed in 1995 by Microsoft" - Uncyclopedia
Introduction to Object-Oriented JavaScript
|
|
|
|
|
Most?
Shucks, i weep to think of the hours i've spent looking through stuff like this... in every mutation of that wretched language i've ever heard of.
Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'
|
|
|
|
|
Regards,
--Perspx
"The Blue Screen of Death, also known as The Blue Screen of Doom, the "Blue Screen of Fun", "Phatul Exception: The WRECKening" and "Windows Vista", is a multi award-winning game first developed in 1995 by Microsoft" - Uncyclopedia
Introduction to Object-Oriented JavaScript
|
|
|
|
|
BustAGutt wrote:
Do While Not objRSPicks.EOF
intPickID = 0
'
' flgProcess:
' 0 = already locked - do nothing
' 1 = not locked both team and score exsit
' 2 = not locked team only
' 0 = not locked score only
flgProcess = 0
flagProDay = 0
If NOT objRSPicks.BOF OR NOT objRSPicks.EOF Then
Do While Not objRSPicks.EOF
Why do you have two loops, in the first place? Maybe you just remove the outer loop...?
|
|
|
|
|
I was working on a C# .net web site. I finished the site and somehow managed to publish the site in the same folder where the original project files were located and lost all the .cs files. How can I get back from precompiled to the .cs version
Help!
|
|
|
|
|
Try Reflector[^].
Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'
|
|
|
|
|
Get your latest working version from the source control application that you are obviously using?
|
|
|
|
|
Hi,
I am developing web application and used crystal report. When my crystal report gets displayed in viewer, I find data in center alignment. Do u have any solution to display data as it is in crystal report.
thanks
Hemant Thaker
By:
Hemant Thaker
|
|
|
|
|
I'm ashamed to even type this, but... You should probably look for a Crystal Reports forum somewhere.
And try the ASP.NET forum for your Report Viewer question.
Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'
|
|
|
|
|
Hi
Select the Object and click the right mouse button and select format and set the alignment.
Kan
|
|
|
|
|
Hi,
I am developing a web application (msvs 2008) and want to implement form authentication. I want to implement it dynamically. i. e user should be searched in database rather than web.config. hows that possible.
please give some sample code if u can.
thanks
Hemant
By:
Hemant Thaker
|
|
|
|
|
Hemant Thaker wrote: user should be searched in database rather than web.config
why you want to do like that ?
|
|
|
|
|
I am developing a project with asp.net.
I use a css stylesheet, but some part of the stylesheet is not working.
#topmenu
{
margin-right: auto;
margin-left: auto;
margin-top:0px;
width: 900px;
height:15px;
text-align:right;
padding:5px;
background-color:White;
}
a.topmenu
{
color: #999999;
text-decoration: none;
font-size: small;
}
a.topmenu:hover, a.topmenu:active, a.topmenu:focus
{
color: #336699;
text-decoration: underline;
}
The other part is working fine.
This css rule looks fine with desginer but when i run the project the css dosn't work..
need some guidelines..
Sanjay Kunjam
------------------------------------------------------------------
"Computers are useless. They can only give answers" - Pablo Picasso
------------------------------------------------------------------
|
|
|
|
|
Sanjay Kunjam wrote: I use a css stylesheet, but some part of the stylesheet is not working.
Not working you say? Ah, a common pitfall. Fortunately, there's an easy solution that'll clear it right up for you.
For each rule, simply change this line:
works: no; to this:
works: yes;
Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'
|
|
|
|
|
Now now... you're getting as bad as me!
Sanjay... try replacing
a.topmenu with #topmenu a
and
a.topmenu:hover with #topmenu a:hover
etc.
"a:focus" I've never heard of; I think you are confusing your CSS with your JavaScript....
|
|
|
|
|
Phil Uribe wrote: "a:focus" I've never heard of; I think you are confusing your CSS with your JavaScript....
Actually, that would apply when an A element has keyboard focus. It's been around for a while (CSS2, if i recall correctly), but IE didn't support it prior to version 8.
You might well be right on the other two - they certainly make more sense the way you wrote 'em. Kinda hard to tell since he didn't post any details.
Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'
|
|
|
|
|
put spaces after :'s too.
|
|
|
|
|
Hi, I'm developing a C# user control to be hosted in IE6. The user control needs to be able to reach out and grab values that are assigned to elements in the Web form that hosts the user control. The Web form is contained in a JSP (not ASP.NET) and uses javascript. Obviously the Web form has a reference to the user control, but how does the user control get a reference to the Web form (parent container) that hosts it so that the user control can read element values in the Web form? I know how to make the Web form pass values to the user control, but I don't know how to make the user control get values from the Web form. Any help would be appreciated.
|
|
|
|
|
Is there a way of using fieldsets with legends containing <h2></h2> tags without getting a wierd effect?
Any Suggestions Welcome.
Thanks
|
|
|
|
|
Why not remove the h2 tags and just style the legend?
It would help if you gave a little more information than just saying you get a "weird effect"... that doesn't help anyone understnad the problem.
|
|
|
|
|
hi friend,
i've a query, pls help me.
suppose, i've a table which has am autoid field. now i am inserting a row in that table.
how i can get the autoid of the new inserted row?
is there any process to get back the autoid when use ExecuteNonQuery( ) method or else?
i don't want to use max(autoid) on the that table, because it can result on concurrency problem.
With Regards,
samrat
|
|
|
|
|
|
samrat.net wrote: is there any process to get back the autoid when use ExecuteNonQuery( )
ExecuteNonQuery() returns the number of rows affected and nothing else.
samrat.net wrote: i don't want to use max(autoid) on the that table, because it can result on concurrency problem.
you can use
SELECT @@IDENTITY as Value .
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|