I have built input fields inside a while not.eof loop
and the name is built from using <%="name"&i%> and the value is a product_id
from the database.the i is then incremented in the loop, resulting in <input name="name1, <input name="name2
and so on. this works no probs, however i haven't got a clue on how to collect this dynaimcally named
input field when it arrives at the form action address page.
I was thinking some kind of for loop but am not sure, and again am not sure where to put the <%="name"&i%> bit
to count or grab the input fields info.
I have a little code to add multiple items to a shopping cart based page. This code works perfect, but it adds all of the info to the same input fields every time it loops. I need it to change the input names each time it loops. Here is the code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
Does anyone have a definitive list of keywords to avoid or prohibit as field names for the tables for an ASP driven program that communicates with a SQL database?
I have a website that allows customers to define tables online and I keep hitting the field names I need to prohibit - "Function" is the latest one. I'd like to just compare the users field names with a list and end this problem for good! Also any VBScript words too?
I am trying to display only certain columns from a table and this is a code that I am using but it is not diplaying anything, can anyone tell me where my code is wrong
<%FOR EACH field IN rstSite1.FIELDS if field.name ="EmpName" then RESPONSE.WRITE("<TH ALIGN='LEFT' BGCOLOR='#B0C4DE'>"& FIELD.NAME & "</TH>") end if
I am designing a shopping site, in the picture the #1 section is a check box behind product name that customer can select that product to buy in #2 section the customer can set quantity of the selected product ok now codes this is the code which I have used to pull out produts and categoris from database and show them on the page Code:
I tried posting this a minute ago but timed out, so sorry if this is posted twice. I want to make an IF statement in ASP using VBscript that will run if a checkbox in a form is checked (and won't otherwise). How do i refer to the form field (checkbox) in the IF statement to do this?
Is it valid to get information from a request.form assign that to a value then use that value to get other content on the requested page.
I return a large rs with multiple feild names. I can't use a static feild def because they would overwrite each other on the loop, SO i create dynamic field names then pass the id back to the next page via javascript. I then use that id to add to the feild name to make sure I get the right feild.
I have an Access database with 58 fields in one table. I wrote many of the field names so that they were descriptive so that others could figure it out in the future. As an example, one field name is called MissingPart14990aDescribe.
Should I be worried about the length of the field name? I'm expecting about 20,000 records a year to be entered into the database. So, five years from now, which would be about 100,000 records, will the query.asp for a list of records be slow due to field name size? BTW, the query.asp would just show a list of the last 3 months worth of records and only a snapshot of about 6 of the 58 fields.
I do a SELECT * from table command in an ASP page to build a text file out on our server, but the export is not to allow a field name rows of records. The first thing I get is a row with all the field names. Why do these come in if they are not part of the table records? How do I eliminate this from being produced? Code:
how to validate a field to make sure that its numbers only. Its basically a form that asks for the user to input the scores. Now , i realiase that you'd have to be fairly thick to enter a letter as the score instead of a number but, i'd like a tidy error message instead of the type mismatch error (that could confuse newbies even more) just incase . I looked into javascript validation but, i really need to do it serverside .
I have an ASP that retrieves data from a SQL server database. Most of the columns are varchar. Some of the fields are meant to populate input fields. Here is my code.
<input type = "text" name="comments" value =<%= rstSimple.Fields("comments")%>
the value is returned, but only the 1st word. It seems it cannot process a space, but when I add the following to a table;
<td><%= rstSimple.Fields("defects").Value %></td>
the whole value is returned. Is there a limitation to the input field and how can I change it?
I want to create some text input fields which they should all have the same size regardless the browser version or type. Because my text input field looks different in size if I view them from a different computer. Is the following coding should solve the problem?
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other contact table id, fname, lastname, contactid, email
I am trying to build 1 hidden input field only, the input is inside a while not EOF loop, currently the code above is building an input field from each product record, so i get one hidden input from each item, what i think i need it to do is build a string from the records and then put it into the input field i.e. the final input field should look like this: Code:
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
I have a website with a Guessbook section. Lately I noticed someone copy and pasted a long http address to promote viagra.. I believe he simply copy and paste the whole link into the text input field and submit several times. It created multiple entries in my guessbook.
How can I prevent this? I was thinking if it is possible for me to write some code to disable people using the control-p to paste text in my text input field.. Can I really do that? What other options do I have?
what i want to do is to put 2 fields in my table , username and password
what iwant to do is to create a page that ask you to unter your username only ,and when u click submit the other page will add new record for the username u enter and will input a randomly alpha(letters and numbers) to yr password field , so how can do this random thing throw the asp"!?!
I need the names of some either ASP or PHP programs that will work like a video rental store. I know there are some out there, but i cant seem to remember the name of them. I would prefer something that is free.
Does any one know how many characters possible in a variable name in ASP? Is it only 15 characters long or could it be more? i.e. could the variable name be ThisIsTheFirstName I do not name my variables like this but I would like to know the max length possible.
I have a web application which saves files to a server and emails the file as an attachment. I generate a unique name for each file by concatenating a unique numeric string so the file name is unique and cannot be accidentally be overwritten. I also store the original name of the file. Is there any way to rename the attachment when I send it so it doesn't have the unique name but rather the orignal one.
im reading from multiple databases, and one restraint is that i must know the amount of columns and the names of the columns before i can display info from the database.my question: can i somehow GRAB or READ this information from each database and then just adapt my Display accordingly
Is it possible with ASP to use arrays with names (e.g user("username") = "ble") instead of numbers (e.g user(1) = "ble")?(I do know of the dictionary object, but is it wise to use that 7 times or more a page?
ive got a small problem, i dont know if this is possible but its bound to be. What im trying to do is request a cookie which contains a database table name and put that inside an sql query...sort of like this
id = request.cookies("tablename") mySQL = "SELECT * FROM &'id'&"
i know that doesnt work, ive tried every other combination .
I am planning my next move on my current website and am looking at doing the following. I am adding a feature where as a database can be viewed on the web page as this has been requested for me to do.
I am pretty sure i can do this without a problem except for getting all of the table names. Is there an SQLQ command where you can say
SELECT (ALL TABLE NAMES) FROM DATABASE.
Antoher way to look at it is to have a seperate table in each of the databases to hold all of the table names.
a script that will automatically pull the names and custom preview icons of image files from a folder and display them on a page? is this possible? i need to use this script on a win 2000 server.
I have two temporary variables that are equal to folder paths. The first temporary variable could equal one folder name or multiple folder names depending upon an if statement so "" & fldr1 & "" & folder.name & "" will not work.
Is it possible to combine both into a third temporary variable? Example:
We have a script the will grab names from a form and display them on the next page but will only get a max of 60 to 80 names depending on the total number of characters of each name.
Can anyone guide us on how to create a script, where if a user copies and pastes 5000 names or email addresses into a form and clicks submit, we can then grab each name and display individually on the next page?
