The problem was with this line of code:
Code:
[B]SQL[/B] = "SELECT * FROM tblform WHERE ccf = " & Request.Form("ccf") & " "
' Open Recordset Object
rs.Open [B]strSQL[/B],conn
devine
Last Activity: Oct 16 '06, 08:51 AM
Joined: Jun 13 '06
Location:
-
Many thanks Sashi,
The problem was with this line of code:
I have changed StrSQL to match SQL and now everything works great!... -
Update Form and use RS to generate CDO Email
Hi All,
I am trying to send an automatic email when an update has been made.
My update statement will updates 6 fields, and dependant on one of the fields, I would like to send an email using CDO.
Once the update is made, I am trying to re-query the database to retrieve all the fields that need to be included in the email, but it's just not working for me!!
This my code to update
...Code:<% Set
-
Combining Function OnChk & function toggleSubmit(sel)
Hi All,
I have a form which checks which Submit button has been pressed and also shows a textarea dependant on an option selected.
The problem I have is that when I include my "display text" code, all submit buttons appear to be disabled.
However, when the "display text" is removed, the buttons function correctly.
...Code:<%@ LANGUAGE="VBSCRIPT" %> <%response.buffer=true%>
-
Hide/Show Text Area
Hi All,
I have some code which enables me to show/hide a text area and switch submit buttons depending on a Select List.
This works great on a page on it's own:
...Code:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
Leave a comment:
-
Hide/Show Text Area Using Select List
Hi All,
I am VERY new to Javascript.
I have been provided with some code, which will enable me to hide/show a text area and change a submit button dependant on a check box.
...Code:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
No activity results to display
Leave a comment: