Checkboxes Not Properly Writing To DB
All i want to do is have a form with 17 checkboxes that writes a value to the database. At this point I don't even care, true/false this/that 1/0 whatever! Setting the Access Database fields to yes/no was not working even 1 bit in the least. They would all be set to off no matter what.
Changed it to text and inserting "That" for off and "This" for on, it comes up, but does it all funky, not in order, all "That"'s at the top, all "This"'s at the bottom, and not even in their respective fields. Code:
View Replies
ADVERTISEMENT
I am tring to create a front end for this Access Database someone has given me and i have trawled through these and other forums for the answer to my question but have not found anything!!
I have used 4 checkboxes in a form with 4 different names, when i try and create a record in the access database which uses the Yes/No Field Type it displays the error, " Provider error '80020005'
type mismatch" when trying to right the value into the field!
View Replies
View Related
I created an RSS script for my readers to use, but I have been having some minor issues with it.
Actuallyit works fine and I have tested it in 3 feed readers without a problem. Still it does not output as perfect XML if you go here you will see what I mean. Code:
View Replies
View Related
The basic gist of this is that it makes downloading of podcast's available (currently) all the time. However I need it to make them available if and only if the date is the day after the podcast is recorded.
Currently the site is making them available the day before they're actually ready. How can I code this so that the asp page knows that the podcast should be available only on the day it is actually ready? Code:
View Replies
View Related
Pretty simple task ... page1.asp calls page2.asp and I want page2.asp to show the HTTP_REFERER (which I expect to be page1.asp).
It's blank when I try from my local machine and from other machines. HTTP_HOST, URL and various other server variables work fine so there is a work around, but I'd like to know why HTTP_REFERER doesn't seem to work
View Replies
View Related
I am unable to get this function to output the correct output. The Subtotal works fine, but the GST and TOTAL are not working properly. GST only shows the integer value and nothing after the decimal places. Code:
View Replies
View Related
I am using what seems to be a fairly simple calendar program that is ASP. I have been successful in adding fields to this App, but for some reason, I must be missing something because when I go into the program to edit an entry, one of the value's (Location) doesn't populate properly.
It pulls up the LAST option (Other) within that dropdown field, instead of the one that had previously been selected. I'm not sure what I've missed, but could someone help? Here is a portion of the code: (let me know if you need additional info). Code:
View Replies
View Related
I have a number value in database and same number value from form. For some reason these are not equal. How can I compare these properly? Code:
View Replies
View Related
I've got a mailing list script which loops through up to 20,000 database records, and fires a customised email out to each via the bulk mail queing function of JMail Pro (email component).
Never having tested this with anything other than 100 records, I'm very wary about executing the script in case it times out or starts to misfire.Is there anything anyone can recommend to make sure this process goes smoothly, perhaps even giving the user feedback whilst it's executing e.g. "sending messages 1-1000", "1001-2000" etc?
View Replies
View Related
When I try to open an aspx file located on my computer it doesn't load properly (i.e not all objects are visible like text fields and such) and it gives me a syntax error stating that it expected a semi-colon (;) on one of the lines.
My page language is VB and so no semi-colon is required and when I load the file through my web server by typing
http://myIPaddress/myfile.apsx
the page loads correctly and functions normally.
Several hard drive formats ago I was able to open aspx files with internet explorer without going through my web server. I am pretty sure I have everything installed like IIS 5.1 and the .NET framework.
View Replies
View Related
I have a process that creates a whole bunch of files in a specified directory. The names of the files are the employee IDs with an .txt extension, so they are like
EMP001.txt
EMP002.txt
EMP003.txt
The background is a bit more complicated so I won't bore you with it, but I hope that I can add a button on the asp page that would
1) go to that specified directory, which is database-driven by the department id, such as
D:DepartmentDEPT001
and I'll be able to figure the directory path from the existing code
2) then loop through each employee id and append the employee name, so the above will become
EMP001JohnDoe.txt
EMP002MaryJane.txt
EMP003PeterKay.txt
The employee names are also database driven and my asp page will be able to provide the information.
What I would like is to have a button that would open the cmd.exe and make the appropriate changes, and then do the rename, and then close the cmd window.
I know that you can have something like: Code:
View Replies
View Related
Ok, I've been hung up on this issue for quite some time now and I would
like some help in getting it to work. I think this may be a setup issue
but I'd like to ask your eminences first.
Here's some backstory: I need to create a VB.NET classlibrary (or another
structure) to use objects for our business logic. However, as our upgrade
is an ongoing process, I must enable this structure to be run in both ASPX
and ASP pages.
Here's what goes wrong: I create a new solution. Create two projects, one
a ASP.NET web app, the other a classLibrary. I put a basic hello world
object into the classlibrary then get a return string from it in both an
ASP and ASPX page. Yes, the classlibrary has the build option checked to
"register for COM interop."
Now, the ASPX page runs fine - but the ASP page gives me the following
cryptic error:
Error Type:
(0x80070002)
/webApplication1/test1.asp, line 3
Line 3 is the Server.CreateObject command for the object in question.
No error string. The error code, when googled, reveals that it's "file not
found." That's about as useful as a kick in the ass. What am I doing
wrong? Why can't my ASP page use this object? If I can only get this
functional then I will have no further issues - we can start moving our
business logic and data logic from the legacy ASP pages to an object-based
back end.
View Replies
View Related
How to do if I have 2 cutoff date for online registration. There are 2 set of fee when user regiser. Early registration and after registration example
below code won't work
today = date
if today < 8/10/2007 then
sql1 = "Select * from MasterDefault where field_name='Registration_For'
and Status=true and RSRV_Field_1=#8/10/2007#
order by id asc"
else
sql1 = "Select * from MasterDefault where field_name='Registration_For'
and Status=true and RSRV_Field_1=#8/11/2007#
order by id asc"
end if
View Replies
View Related
I have a textbox which I need to display the data stored in a variable called "fname".
So, what I've written is:
Response.write("<input type=""text"" name=""fname"" size=""20"" value=" & fname & ">")
assume that fname="jason smith"
and, the textbox only ends up displaying "jason". So, anything after a space isn't displayed.What could be wrong? I know the <%=fname%> thing works, but that doesn't work within a Response.write.
View Replies
View Related
The following code is not working properly in IE6 but it does work for mozilla firefox. I am trying to open a new popup window without affecting the frame from "where" it came. But what happens when I click on the link is that the popup window is displayed correctly but the frame then changes to my default.htm. It is supposed to stay the same
here is my code
Response.Write "<td><a href=" & """" & """" & " onclick=" & """" &
"javascript:window.open('desc.asp?msg=" & tempdesc & "','" & rownum &
"','toolbar=no,location=no,directories=no,status=no ,menubar=no,scrollbars=yes,resizable=no,width=600, height=600,left=300,top=300')"
& """" & ">" & left(tempdesc,50) & "....</a></td>"
View Replies
View Related
I used onMouseOver and onMouseOut to switch the image when mouse over the image. But for some images, this event doesn't work and some yes while i'm using the same method to call the event. Code:
View Replies
View Related
I am having trouble loading the result of a VBscript split function into an array. The script is supposed to take the user's login name (the form for this is name separated by underscores such as john_foo or lisa_wilson), split it at the underscores, and load first, middle and last name into an array. The problem I keep getting though, is that I am getting a type mismatch error. Here is the code:
<%dim LogName, NameArray(), FirstName, LastName, MiddleName, LastPage
'Get NT authorized login info
LogName = request.servervariables("logon_user")
NameArray = Split(LogName, "_")
for x = 0 to UBound(NameArray)
response.write NameArray(x) & "<br>"
next
%>
The FirstName, MiddleName, LastName vars are supposed to take the array values later.
View Replies
View Related
I'm having a problem with a couple of things. The first is that I am using a loop to populate my table with the proper variables. When it comes across one that is empty it is leaving the cell blank.
The problem isn't that it is leaving it totally blank but that it isn't even putting an outline for the cell. This leaves huge chunks of white space here and there and looks bad. Code:
View Replies
View Related
I am attempting to send an HTML email which a hyperlink that will change based on the user's session ID. I need the hyperlink to display as:
http://www.synergeticsusa.net/admin/shop_cart/detail.asp?id=
WHERE the id = Session("MM_UserID")
However I cannot seem to code this into the html string in the correct syntax, to where id=1 or id=2, etc. Does anyone know the anwser to this problem?The basic code I am using can be found below.
html = html & "<a href=""http://www.synergeticsusa.net/admin/shop_cart/detail.asp?id="">"
html = html & Session("MM_UserID")
html = html & "<IMG SRC=""myImage2.gif""></A><BR><BR>"
html = html & "</br>"
View Replies
View Related
Am facing a problem when trying to display a carriage return in firefox in a title attribute,i ve tried using VbCr and chr(13) ,in either cases a strange character appears instead of the carriage return. does anyone know about this error. The code looks like this:
titles(iday) = titles(iday) & chr(13) & objRS("event_title")
<a href="javascript:showevent('0<%=links(i)%>')" title=" <%=titles(i)%>"><%=i%></a>
Am not having this strange character when running it on explorer.
View Replies
View Related
I have a page with 2 frames. The first one has a link that loads a page in the second frame. This page has a button on it. When the button is hit, the page does some processing and loads another page in the same frame (the second).
I use ASP and response.redirect or javascript in the onclick event of the button to do the redirection. When I refresh the page by clicking the button on the browser (IE), the second frame becomes empty. Please note that the src attribute of the frame is not set.
If I set the src attribute of the second frame to some asp page and then navigate to another page inside the same frame, when I refresh the page, the initial asp page is loaded in the frame regardless of the asp page currently loaded into the frame.
It seems that when you refresh the page, the frames are reinitialized no matter what pages are currently loaded in the frames.
I solved the problem by redirecting to the main page in the top frame, passing some parameters and resetting the src of the frame to the desired asp page. Thus, when the page is refreshed, all the frames are properly refreshed too.
View Replies
View Related
I have a form that has checkboxes. I would like when the user clicks the
process button the next page will display the value of the boxes that were
checked.
View Replies
View Related
Do any of you guys know what the value of a check box is.
I am offering two ways to download, posting to a diff form and using info from there but do not know which check box has been ticked??
View Replies
View Related
To get the checked value of checkboxes I use this code:
Code:
For Each subitem In oFileUp.FormEx("imgCheckBox")
...
Next
How can I get the value of those unchecked checkboxes?
View Replies
View Related
I am trying to set up a page, with some input fields, which
are mandatory. Then there is a checkbox, when it is
checked, the input fields do not need to be filled
(not mandatory anymore). At the moment, even though
the checkbox is checked it asks to fill the mandatory
fields.
View Replies
View Related
I need to add a master checkbox, clicking on which, will select all the child checkboxes. Unclicking it, will unselect all the child boxes.
Exactly the same way as hotmail does. I know, I need to write a javascript for that. But the problem is, the child checkboxes are being
populated from the stylesheet code (embedded in the .asp page). It is also not under the <form> </form> tag. Following is the code:
View Replies
View Related
I've never used checkboxes in ASP, well nows the time i do it.Im creating a login script, and want the user to be able to click on "remember me"it keep them logged in.
how would i get that in ASP. how would i make it detect wether or not the checkbox has been selected or not?
View Replies
View Related
I'm trying to create a form that has checkboxes on it that when a user checks the particular boxes, and submits the form, it performs the query based on the selections.
I'm using MS Access and FrontPage. I'm having problems passing the information from the form to the query and then to the database.
View Replies
View Related
How can I use checkboxes to send out an email based on which checkbox was clicked?
For example, I have an html table that is constructed dynamically which contains information about events stored in a database.
The table has checkboxes out to the left side (similar to hotmail) and when I check however many boxes, and click submit, I want to send an email to each address that is associated with each record that I checked its box.Something like "for each checkbox clicked, select the ID and email address associated with it, and dispatch an email"
I have everything set up except the asp loop and select statement that will help me achieve this.
View Replies
View Related
i have some 15 checkboxex on a form... i want to 1st check the no. of checkboxes that are checked?? and then loop it that many times adn insert the quantities the user enters in the text boxes.
do i need to group the checkboxes....hwo can i do that??? how to know which checkbox is checked because out of the 15 checkbox say 1,5,7, 9th are checked then i 1st need to get the id from the database adn then based on htat id retrieved i need to insert values on another table.
View Replies
View Related
give me a working example on how to use checkboxes ?
View Replies
View Related
A list of names is printed out from a Table as a list of checkboxes:
<tr>
<%while not rstLogin.EOF%>
<%
dim name
name =rstLogin.Fields(0)%>
<td><input type="checkbox" name="<%=name%>" > <%Response.write (name)%> </td>
</center>
</tr>
<%
rstLogin.MoveNext
wend
What I then want to do is add "Checked" names to another table. How do I do this?
View Replies
View Related
I've been using Dreamweaver to develop some simple database connectivity. So far everything works, but could be more user-friendly and flexible.
I have an Access database with 4 document types. I have search forms which allow users to enter a keyword and search for one specific document type. The problem is I need four different search forms this way. What I would like is to include 4 checkboxes and one keyword textfield. Code:
View Replies
View Related
