Jump to content

billylariviere@hotmail.com

Members
  • Content Count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About billylariviere@hotmail.com

  • Rank
    Newbie
  • Birthday 10/20/1973

Profile Information

  • Location
    Rouyn-Noranda, Canada
  1. would it be possible to update an XML file with the content of the new selection directly from that code?I only have one node in the XML file. This node would hold the selected message.example:<message>this is the selected message</message>every time I would select a different radiobutton, the message would be replaced by the new selection.I don't know where to start
  2. Hi, I just can't figure how to: correctly prepare a variable from an ASP pageDim messageChoisimessageChoisi=rsMessageBanner.Fields.Item("memPostMessage").Valueresponse.write("messageChoisi="&rsMessageBanner.Fields.Item("memPostMessage").Value) I know the variable works from the ASP page itself because the Response.write returns my variable correctly.I don't want my variable to show on the html page (I just want my variable to be available for Flash), so I remove the Response.write line.is it the right way to do it? get my variable into Flash with ActionScript 3here's my ActionScript
  3. Okay, by the way, thanks for your patience I removed the problematic tag.I changed the name of the buttonGroup radioChoisi:<input <%If (CStr((rsMessageIndex.Fields.Item("bitMessageChoisi").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> name="radioChoisi" type="radio" value="<%= rsMessageIndex.Fields.Item("intMessageID").Value%>" onchange="submit()"/> to MM_recordID: <input <%If (CStr((rsMessageIndex.Fields.Item("bitMessageChoisi").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> na
  4. these lines: <input type="hidden" name="[b]MM_update[/b]" value="frmMessageChoisi" /><input type="hidden" name="[b]MM_recordId[/b]" value="<%=(rsMessageIndex.Fields.Item("intMessageID").Value)%>" /> are emmbeded at the end of my form tag. I think they relate to the following functions:here is MM_update (from the first line): If (CStr(Request("[b]MM_update[/b]")) = "frmMessageChoisi") Then If (Not MM_abortEdit) Then ' execute the update Dim MM_editCmd2 Set MM_editCmd2 = Server.CreateObject ("ADODB.Command") MM_editCmd2.ActiveConnection = MM_connUsers_STRING MM_editCmd2.Comm
  5. I replaced the line 87 and IE gives me that error message: The record ID i'm trying to put there is the unique key from my database, which corresponds to the entry number of each checkbox in my database:I want intMessageID be to the value of each radioButton on my web page. Then I want my form(frmMessageChoisi) to update my database, updating all the checkboxes at once, leaving the newly selectedentry(bitMessageChoisi) to TRUE.Is it possible to do that ?
  6. Sorry, maybe I should start from scratch. It will be easier that way. here's the problematic page : http://web2.uqat.ca/opiaPlayground/soccerB...ewsEditHome.asplogin:testpassword:testI made a dynamic table which holds data from an Access database. I then added a radioButton at the end of each entry of the dynamic table. I was able to reference the radioButtons to the checkbox entry of my database so we can see which entry is selected. I selected only one checkbox in Access so I could make use of the checkboxes as a radiobutton group in ASP. I embedded the dynamic table in a form so when I cho
  7. I tried that, but no change.I forgot to mention that I used 2 recordsets because when I used the main one (reMessageIndex), I had the following error message: and the line 526 refers to :<input type="hidden" name="MM_recordId" value="<%=(rsMessageIndex.Fields.Item("intMessageID").Value)%>" /> At the end of the Whole code Page I posted previously, you can see that the value is rsMessageChoisi.Fields... instead of rsMessageIndex.Fields... It was an attempt at avoiding an error, not so clever of me.......I tried some Response.write to verify if rsMessageIndex.Fields.Item("intMessage
  8. anyways, here's the whole page.... <%' *** Restrict Access To Page: Grant or deny access to this pageMM_authorizedUsers="1,2"MM_authFailedURL="loginNews.asp"MM_grantAccess=falseIf Session("MM_Username") <> "" Then If (false Or CStr(Session("MM_UserAuthorization"))="") Or _ (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then MM_grantAccess = true End IfEnd IfIf Not MM_grantAccess Then MM_qsChar = "?" If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&" MM_referrer = Request.ServerVariables("URL") if (Len(Request.QueryString()) > 0) Then M
  9. Should I write it like this : "UPDATE messages SET intMessageID = ? WHERE bitMessageChoisi = ?"or like this:"UPDATE messages WHERE bitMessageChoisi = ? SET intMessageID = ?"?The first option gives me that error: Microsoft JET Database Engine error '80040e21' Cannot update 'intMessageID'; field not updateable. /opiaPlayground/soccerBoreal/newsEditHome.asp, line 89 and the second option gives me : Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /opiaPlayground/soccerBoreal/newsEditHome.asp, line 89 Would it be easier if I just sent the whole code ?
  10. I changed the value to :rsMessageIndex.Fields.Item("intMessageID").Value. It is the unique key of my message Table. but the form still doesn't apply the changes to the message table. The messages that were checked are still cheked, and thoses who weren't still are not.Is it okay if the value numbers are not 1,2,3,... but 13, 16, 17,....? And they might not stay these numbers as the administrator can delete and create new entries in the database.here's the updated code: <form id="frmMessageChoisi" name="frmMessageChoisi" method="POST" action="<%=MM_editAction%>"><table> &l
  11. Hi, ASP newbie here,I made a dynamic table which holds data from an Access database. I then added a radioButton at the end of each entry of the dynamic table. I was able to reference the radioButtons to the checkbox entry of my database so we can see which entry is selected. I selected only one checkbox in Access so I could make use of the checkboxes as a radiobutton group in ASP.I embedded the dynamic table in a form so when I choose a radio button (onchange), the form refreshes the page.There seems to be some missing information in my code since the radio buttons don't update my database.qu
×
×
  • Create New...