I have been provided with a DSN, user name and password for one of my
clients sites.
I'm not an ASP developer and need to view all the contents of this database.
I usually work in PHP but only have ASP available on this server.
I want to open the database and simply output all the contents into a HTML
page.
I have a "csv file" as a database.
The 1st row contains the field names:
Orion.Accounts.AccountName,Orion.Accounts.Address1
the code I use normally works:
<%=rs("Orion.Accounts.AccountName")%>
Although in this case is doesn't because the fieldnames contain full stops.
how to modify this line:
<%=rs("Orion.Accounts.AccountName")%>
My question is this: how do I get a value from a listbox to assign to a variable (elementary I know)? Code:
View Replies View RelatedWe 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?
Anyone have any advice on getting a recordset of all tablenames in a database? I have an access database that I am constantly adding tables to.
I want to have code that will lookup all tables and populate a selectbox with the tablenames so that I can click to look at each table individually.
if there is a way to open a folder and return the files it contains back to the webpage?
View Replies View Relatedis there a way to list the contents of a folder with pages? i can already list the contents but the folder has a lot of files and takes a lot of time to load. so in order to lessen the time to display the page, i need a script that displays around 20 files per page.
View Replies View RelatedI 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.e newname= REquest.Form(<%="name"&i%>)
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?
When using RS.getRows how do I go about getting the field names from the database as well?
View Replies View RelatedI 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
NEXT%>
I am writing vbscript code in an .asp page.I need to display field values from a sql table consisting of several fields, one of them is of type "Long Text".This field contains XML data. I like to be able to assign vale of this field to a variable display it and write out a text file using file streaming object.
When I set a variable to this field, the data is truncated.I am using "Recordset" object, is that not an appropriate type to retrieve <long Text> fields.
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:
View Replies View RelatedI 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?
I need to evaluate a field's maximum value and then do an if
conditional:
if rs("havesubP") = true and rs("displaygroup") < MAX then ....
whereas MAX represents the biggest value in the records for the
displaygroup field (an integer datatype). I get an "Either BOF or EOF
is True, or the current record has been deleted.." error if i put any
type of comparison number (of course MAX is not a vbscript keyword)
that is larger than my largest displaygroup value in the dbase , as I
will loop thru all the records once this condition is met.
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.
Id = Request.Form("Id")
SQL STUFF
CheckedID=Request.Form("Name_"&Id)
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 am trying to have a web page list the contents of my database table. I have been trying for ever and cannot find what I am doing wrong.
Here is my code: (I hope it is not a mess I am new too this)I have included comments to walk myself through this. Code:
I've created a web form that will post to an Access database. All of
the form fields correctly save to the database upon submit using:
<td><font face="MS Gothic">Site:</td><td><INPUT TYPE="TEXT"
NAME="Site"></td>
Below is what I have for one of the drop-down menus. Could anyone help
with how to add the VB code to this so that the selected menu item
will submit to the database as well? Code:
Ive got an accces database with a couple of table in it at the moment but this will grow to 5 tables pretty soon then maybe more after that.
I would like to be able to populate a drop down menu with all the table names in the database any ideas how to do this or if its even possible.
I have a page that has a form on it which has a dropdown list on it. It connect to an sql database and populate the list. What I would like to do is make the list editable so that if the data returned doesnt contain what I want, I can type in the data I require which will then be updated to the database when the form is posted. Hope I've made sense, you may be able to tell.
View Replies View Relatedi have field company_name and what im trying to do is
A
Abrahams Company Alexs company AZ''x Company
Adams company Adrians Company
B
Bills company
Bobs Compay
I want the names spread over 3 columns and by alphebet category. can yous ee by the example what i mean? and is this easy to achieve?
What I would like to happen on this page is that when a user selects a company name from a drop down list, his selection autopopulates the cID field based on the selection. The drop down list is getting its choices from the customer table.
As I am still a novice, I am sure there is a way to do it I have not been able to get it right. Code:
I have a survey/member form that gathers information. I would like to have a drop down list on a page that a user selects, either 1, 2 or 3.If 2 or 3 I would like to show on the form another field for information gathering ie:if a user has 1 cat, fields for cat name, sex & age show.
if a user has 2 cats, 2 fields show instead of one for each, and the same
for 3.....
i am selecting a field from a list .i want to show all the list after searching on the basis of that selected field from database in another list box which is on the same page.
I am trying to list a database (SQL) i a dropdown list but I just cant get it to work... I am writing in ASP. This is some of the code:
mySQL="SELECT ras.raser FROM ras ORDER by raser"
<tr>
<td width="220">Raser</select></td>
<td width="342" height="23">
<select name="idRas">
<%do while not rstemp.eof
pRaser= rstemp("raser")
%>
<option value='??????????' </option>
</select>
</td>
</tr>
An HTML page that have two dropdown list whit different values:
1. Dropdown list 1(tblname1) =values with different location's. After user
has selected one value from the dropdown it should show values from
(tblname2) in the dropdown list2.
2. When user select an value from dropdown list2(tblname2) and click on a
button "GO" it should show all the value's from the database that been
selected in dropdown list1 and 2.
Please someone please help me out with this problem!?
This thread is not so much a big problem, but more to receive comments on my approach. You may have some other tips or advices of where to go or where absolutely not to go with my attempts. Code:
View Replies View RelatedI need to have three list boxes automatically populating each other, (ie
when region is selected from the first listbox, it will populate
automatically the second one which is the TOWNS and when the town is
selected is should populate the third one AREA) all data is in the database
in one table.
I need to compare the files in a folder to ones that are entered into a database (filenames list) and update it to include ones that dont have entities.
Whats the best way to accomplish this ? I'v thought of creating an array out of the physical file entities then rolling through the database and deleting the array entities that already exist; that way I end up with an array of filenames that need to be entered into the DB. that way just a thought (I wouldnt even know how to do it) but I want to think it through more thoroughly before starting the code:
Is there anyway to store a list of data in an access database.
For example if i have several input text fields for a customer to add descriptions of a particular item, this list should then come together and be stored in one place in the database. This information should then be displayed in a list when retreiving the data from the database.
ive tried to explain what i am trying to achieve, if anyone can advise me on how to do this or for a better way to accomplish this.
what is code for populating a list menu with data from a database. also the default(first) option in the list should be "ALL".
View Replies View Related