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 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 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:
I've created a little search engine that works fine, but I want to highlight the keywords in an article. Using the replace function is OK, but its not very good when covering different cases. Its fine on single word searches but no good with multiple words. eg. if I search for "dog", I can do a replacement on "dog", "DOG" and "Dog" using the replace function. If I was to search for "black dog", I need to cover all possible variants. ("Black Dog", "BLACK DOG", "black dog", "Black dog", "black Dog") Is there any way of getting this to work?
Im trying to create a function to where when I call the function, it returns the next keyword from the list, and the list is only a string of keywords split by comma's. I know how to split it, but I dont know how to have the function call out the next keyword. keyword1,keyword2,keyword3,keyword4.Code:
<%=Function1(keyword)%> 'Will spit out Keyword 1
<%=Function1(keyword)%> 'Will spit out Keyword 2
<%=Function1(keyword)%> 'Will spit out Keyword 3
<%=Function1(keyword)%> 'Will spit out Keyword 4
Then I need it to start over again once it gets to the last function. This function will be spread out across the page.
my problem is searching. i want to search words within webpage which is stored in one directory.it is different from normal directory searching beacause i am searching inside the webpage.
so i want to omit all that html tags or other asp codes. also i want to know that is there any way to store webpage inside the database. it will be efficient than storing inside the directory.
I am trying to make a search page. Once a serach word or words is put in I need it to serach multiple product tables and output the description of any prioduct if the search word is present in the description.
However, If i put in 2 keywords like "paper sticker" I get no results. How do you search multiple keywords? Code:
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?
Does anyone know of a script or library that provides a way to match first names with common nicknames or shortened forms?
I'm developing criteria to determine whether two database entries represent the same person, and I definitely want people named 'Bill' and 'William' to score as having the same first name, for example.
in my drop down dont want to show country names like United States and Canada but its still showing Code:
nusa="United States" ncanada="Canada"
Set rs = Server.CreateObject("adodb.RecordSet") strcountry="SELECT * from tblCountries where CountryName Not In ('"& nusa & "," & ncanada & "')" rs.Open strcountry,cardconn, 2, 2