how's the best way to handle yes or no check boxes in a form and DB?
I am building an apllication using ASP and MS SQL 2000. The form will have a total of
34 yes and no check boxes. That is, users will have to make a choice(s) by checking either one.
So my question is, for efficiency on the SQL side, what's the best data type to use?
I am trying to create a database submition type interface which is dependant on the selection of three check boxes. The form contents will always be the same type of information;;; name address etc. The user must decide which db to write their details to.. So if check box one is selected then it writes to database a. If the other two are individually selected then the script will write the form details to another database b and c. If all three are selected then the script will write to all three databases a b and c .
Is it as simple as creating three connection strings and assigning them to variables
Say i have a table with check boxes for every row. I would like to have a feature where when the user clicks the checkbox the column background color changes like the one in hotmail and yahoo mail.
View Replies View RelatedI have this form which the user will fill online.Now the form has 3 checkboxes giving a user the option of selecting which person/persons out of the three listed should get the form email when he hits submits.
So the form has three checkboxes and each checkbox will have a name of a person next to it.The user just needs to check it (one name or all names out of three) and after he hits enters a mail shud go to the respective selected people.I was thinking of using CDONTS to send mail..but i cant figure out how i shud do it with this mutliple checkbox scenrio?
I have a asp page that I am trying to use Javascript to validate wether or not a value is selected. I have two check boxes on a form, cbx1 and cbx2. I only want to throw an error if both of them are left unchecked. Here is what I have: Code:
if ((cbx1.value!=1)&&(cbx2.value!=1)){
alert("Please Choose How We Should Contact You")
return false
}
however, this always throws the error, even if one is =1. I thought that the And comparison for JS would only run if both arguments were true.
Ok i'm trying to do a simple delete from what is checked. can someone look at my code and determine why it's not working i when i submit with nothing check it works when i submit with something check it gives me The page cannot be displayed.I'm still new at all of this so excuse my messy code.
View Replies View RelatedI need to make a check for file type at client end, ie allow only files that are images to be uploaded and prevent the others. I tried using the HtmlInputFile.Accept Property, but it somehow doesn't seem to work.
moreover, it claims to support only few browsers. Also, javascript in itself, gets very dirty, if i start making validations for every thing. Does ASP.NET support any control which can cause these validations? what is the most elegant way to do this?
I have used ASP code to load data into two select boxes. The code below is used to move the selected data back and forth between the boxes.
I am having problems retreving the data from the boxes after the user has moved any of the data:
If the data has been moved by the below code; when i try and load the data back into the database i cannot retrieve the data using:
request.form("Clients1").item(1) and it will not show up using
request.form("Clients1").count
If i dont move the data i can retrieve it using: Code:
I need some ideas in this if you can please help me.The folllowing is the scenerio:
I have a form which is the normal html with some validations and scripting done in javascript and i have a text box by name ticket no when the user enters a ticket no which exists in my database I need to update all my other form textboxes and textboxes with the data in the database else I need to show a alert that this doent exist in the database.
usually the event handling is done in javascript but now i have to call server side connection I have no clue how to do this.
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
View Replies View RelatedWe are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.
THE RESULTS:
(returns a blank page with only HTML Titles)
THE SCRIPT:
(you may notice this is a modified sample script): Code:
I have the below page built to display - and it works, as long as there is current inventory for it to display. However, it just occurred to me that when the user first logs in, there will not be any listings to display to them (nothing to pull from inventory).
Can anyone tell me how to alter my below code to still allow the user to add, delete, or edit listings? In other words, when this page comes up, it will not display the link for them to add information to the database. Code:
how to check the availability of data in table. If there is, I want a messagebox to prompt the users.
View Replies View RelatedWhat data type do you use for this input -- uyen8976? how do you convert it to a string? how do you query it?
I tried to create a table in sql with this field
invoice char not null
inv=request.form("inv")
qInvoice= "select invoice from ItemMaster where invoice=" + cstr(inv)
rs.open qInvoice, "dsn......"
when i tried to query this field, computer didn't understand what cstr(inv) was. It kept reporting errors.
However, i couldn't use varchar data type for uyen8976 either. The computer didn't let me convert "uyen8976" into a string.
i define Dim total as int but the total's value cant exceed a certain big amount. is there any long data types or double, which can be used?
View Replies View RelatedI want to know how to search a database if a particular data is contained in it and then if the data is not there the page should go ahead to insert the data into the database and then redirect the user to another page but if the data is alraedy there it should go ahead a query another table where the user infomation where also stored.
View Replies View RelatedI have a few check boxs on a page. What I want to do is if a box is checks a value of Y is stored in the database. Could you please show me how to do this?
View Replies View Relatedi am getting this error Code:
Microsoft OLE DB Provider for SQL Server error '80040e07'
Syntax error converting the varchar value 'Canvas' to a column of data type int.
/store/administrator/special.asp, line 98
what i am doing is selecting an item from the drop down and i have textbox i want to display the items price from the table here is the code:
I am trying to do a comparison between two values and am getting the following error:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
The code that is creating the error is as follows:
sb = Request.Form("storyboardscreen")
if Not Lcase(Request.Form("AllStoryBoard")) = "all" then
whereClause = whereClause + "theStoryboard = " + sb
end if
I am using the statement to build the where clause of my query. The sb value is retrieved from a pull down menu and "theStoryboard" column is the db is of data type "text". The values stored in the field are 12 digit numbers. I have tried doing a cstr to sb but that doesnt work, any tips on what I am doing wrong? I am using asp with an access db.
I'm grabbing data from an XML web service and storing the values in ASP variables. I'm trying to apply the cDbl function to values returned and I'm getting the following error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cDbl'
The data prints to the screen just fine
can i put my operators into an arry, as i want to loop them later in a loop. but i have problem declearing the data type of the arrys.
Dim operatorsArray(4) As ?????
operatorsArray(0) = "+"
operatorsArray(1) = "-"
operatorsArray(2) = "*"
operatorsArray(3) = "/"
what should the data type be to work. can i have an example of how i am going to
use it.can it be done this way eg.
2 operatorsArray(0) 3 operatorsArray(0) 4 operatorsArray(0)does the above interperate as 2 + 3 + 4?
I am calling a javascript function in my asp. I am passing a recordset value, a 7 digit integer, to this javascript function. However, in the function this value is not coming in correctly. say for example i am passing 0360001, in the function when i pass it to another window, its going as 122881.
I am asuming its because of the size of the default integer data type. If you think thats the reason, how can set a long integer data type to this value, if that can be done in asp.
I m getting mismatch datatype error. How will fix this?Id is number, and route_knowledge is text.
Select route_name from routes where ID in (select Route_knowledge from drivers where ID =10)
Is there a way to print a variable's data type - like int, string, dbl?
View Replies View RelatedIs this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
I have been trying to delete a record from a database using the following code:
strQuery = "DELETE * FROM tbl_bookings WHERE fld_booking_id= '" & delID &"'"
objConn.execute(strQuery)
it looks fine to me but I am getting the following error message:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/cancel.asp, line 50
Line 50 is the objConn.execute statement.
Is this something simple?
I am doing a simple profile update webpage, I keep getting this error and can'y figure out how to fix it. I have included the code. The only field in my database that isn't a text field is my userid field which is an autonumber field.
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression ASP Code:
I am trying to insert data from one table to another but it always errors me on type mis matches or parameters.
Basically the SQL statement looks like this:
sql6 = "Insert Into tblWeeklyFixtures_Div3 Select * From tblAllFixtures_div3 Where GameDate > date() <=date()+7"
conn.execute(sql6)
and it gives me error:
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/DIGFootball/Admin/FriDiv3/update2.asp, line 142]
I tihnk it has to be that i havent declared that i will be importing into a Date/Time field in access but when i change this in acess it gives me more errors so for a peacful life i chnaged the field back to text but by doing this the above SQL statement is pretty useless.
i going to execute this sql statement...and the error come up.. why?
Select * From members Where ID = '123'
pls note that the type of ID is autonumber
is it becoz of type of ID is autonumber? how to solve this problem??
Consider the following code snippet:
<%
Dim intA, strA, strB
intA=5
strA="Hello World"
strB=strA+intA
Response.Write(strB)
%>
The above code generates the "Type mismatch" error pointing to the line strB=strA+intA but why doesn't VBScript implicitly cast the value of intA into String when intA is concatenated with strA?
Im having trouble in storing blank or space value on a variable wich data type is Date/Time, if i make a statement like this
Field Data Type
CPARCAVEDate Date/Time
strCPARCAVEDate = rstFEVV.fields("CPARCAVEDate").value
if strCPARCAVEDate = "" then
counter = counter + 1
end if
The value doesnt increment. Do you guys have an idea how to recognize a no value.
I am getting the following error and not sure what it means.
Microsoft OLE DB Provider for ODBC Driverserror '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. /addgift.asp, line 18
Code:
I'm getting the error: Data type mismatch in criteria expression every time I try to run this bit of code:
View Replies View Related