+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 11 to 20 of 20

Thread: Syntax error near =

  1. #11
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    For "PlanYr" or in general?

  2. #12
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,547
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    I guess both.
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.


  3. #13
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    Because I don't have an unique rowID since this is a mass/batch update.

  4. #14
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,547
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    Do your input fields reflect this counter? Meaning, input1, input2, input3, etc.
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.


  5. #15
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    Yes, like so...these are hidden but the visible ones are like this too.


    Code:
    <input type="hidden" name="ItemIDRow52" value="59"></TD>
    <input type="hidden" name="PlanID52" value="1"></TD>
    

  6. #16
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,547
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    Ok, and what about the PlanYr?
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.


  7. #17
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    No counter on it. I just have it like so:

    Code:
    <INPUT TYPE="hidden" NAME="DistrictID" readonly VALUE="<%= sDistricts %>">
    	<INPUT TYPE="hidden" NAME="PlanYr" readonly VALUE="<%= sPlanYr %>">	
    <INPUT TYPE="hidden" NAME="PlanID" readonly VALUE="<%= sPlanID %>">
    
    Compared to these with counter (i):
    Code:
    <input type="hidden" name="ItemIDRow<%response.write(i)%>" value="<%=rs("ItemID")%>"></TD>
    <input type="hidden" name="PlanID<%response.write(i)%>" value="<%=rs("PlanTypeID")%>"></TD>
    

  8. #18
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,547
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    Okay, so now do you see why your previous code didn't work and Request("PlanYr") does?
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.


  9. #19
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    Yes

    But question, does it matter if it goes inside the "Do loop" or should it go on the outside?

  10. #20
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,547
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    Well, I see no need to reassign the variable inside the loop if it's going to have the same value each time. If you have a plan year for each row, then it would be different and you'd have to use the counter.
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.


+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Similar Threads

  1. Question ASP Upload syntax error (class aspform)
    By buck1109 in forum ASP Development
    Replies: 5
    Last Post: December 18th, 2009, 03:30 PM
  2. syntax error? Expected ')'
    By Rebelle in forum ASP Development
    Replies: 1
    Last Post: October 21st, 2008, 04:10 PM
  3. Syntax Error with Arrays
    By BLaaaaaaaaaarche in forum ASP Development
    Replies: 4
    Last Post: August 18th, 2008, 04:14 PM
  4. OleDbException: Syntax error (missing operator)
    By richyrich in forum SQL Development
    Replies: 2
    Last Post: July 24th, 2008, 07:37 AM
  5. syntax
    By Shem in forum .NET Development
    Replies: 1
    Last Post: July 9th, 2008, 06:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO