i 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?
I have to fix an asp database site, that may or may not have ever worked properly. I keep getting the following error:
"ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal."
I have researched and found that this is happeneing most likely because the script is requesting a field that doesn't exist in the database (maybe a mis-spelling). I can't find the code to display a list of columns in the database.
I'm using the following code to read articles from a db and show them by columns and not by rows. Code:
View Replies View RelatedI want to be able to display my recordset as follows:
a e
b f
c g
d h
Instead of :
a b
c d
e f
g h
Any links to some examples?
I thought its more space efficient of displaying the data in multiple columns (let's say 2 columns for now), instead of one loooooooooong column in a table, are there a simple script of coding that can do just that?
How about 3 columns?
I have let say 100 record from database, then I wanted to display in 4 columns, so each column will have 25 records. hot to d that?
View Replies View RelatedI will be eternally greatful if someone can provide snippet of code,
URL or reference material that shows how to display data in a "n
colums * n rows" format.
I am new to ASP and have looked everywhere that I could, but I have
not found an example where data can be formatted to be displayed in a
3 * 4 foramt, like many of the professional sites would do (actually
rows and columns can be any number of rows and columns) All the
examples that I have seen, show data displayed in a top down format.
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
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 RelatedI 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 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.
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.....
anyone know any homepage that might help me to list the data out in a page. i wanna do it like in 2pages that one is going to be the one who maintain data. another one is to list all the data out from server
View Replies View RelatedI use while-loop the show the table content in web page. e.g (bookingno,
booking date,customer no)
However, the client need me insert one column (confirmdate ) and allow the
user input and update the date .
This is just a test before i apply to my system. I have a student:
Table: Pelajar
pelCode : 1001 (datatype: Number)
pelName : Michael Lee (datatype: Text)
countryCode : US (datatype: Text)
Table: Negara
countryCode : US (datatype: Text)
countryName : United States (datatype: Text)
i want to display this student's country name in the dropdown list as a selected country name and at the same time, populate all country names in the dropdown list. but, i can't make it. i saw the selected country name is country name that at the 1st row of table Negara ......
I have an ASP form that users enter a number into. The form then posts
the number with a hidden login and password to a web address which
opens in a new window. However, I want make sure that the number they
enter is not one of the numbers I have in an Access database table that
contains a list of numbers they are not allowed to enter. How can I do
this?
I have a large classic ASP web application which needs to now support chinese
character entry (I don't have to worry about the UI yet - the data entry
people can read english). Other than changing the database fields over to
"N" data types, do I need to do anything to the actual entry fields (input,
textbox) on the various forms to be able to capture the information. Some
users will be entering the information in english, while others will be
translating the same info into chinese as they enter it.
I know this is probably much easier in .net, but we have yet made that
transition. Now that 2.0 is available, it should be much more viable.
I tried to Display data from field DB (mysql) into a Textarea to edit the text. The code I used is : Code:
<textarea name="warranty" cols="90" rows="6" class="style55" value="<%=WARRANTY%>" type="text"></textarea>
And it does not displays the data.?
I'm trying to select all the records of a Database that have the value of the "giorno" ( giorno = day in english.. i'm italian) field bigger than today.... but there's something wrong in my query. The date is in the format dd/mm/yyyy Code:
View Replies View RelatedI have an ASP variable called IRNvar:
If IRNvar(0,num) = "True" then
IRNvar(0,num) = 1
else
IRNvar(0,num) = 0
end if
In my sql database I have a True/False field called VariantFlag which is a bit data type. The IRNvar value is numeric. I am trying to insert the 1 or 0 into the database so that the field shows true or false accordingly but I get a 'Type Mismatch' error. Here's the insert statement:
SQL = "INSERT INTO Documents (CNID, DocumentPrefix, DocCategory, DocumentName, VariantFlag, PartNo, PartDesc, NewIssue, StatusID) VALUES ('" & CNID & "', '" & IRNprefix & "', '" & IRNcat & "', '" & IRNnumber & "', " & IRNvar & ", '" & PartNum & "', '" & IRNDesc(0,num) & "', 'A', '5')"
Is there a way to convert the number to the right data type? Am I doing something wrong? I'm quite new to all this so it's probably something silly.
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 have a page that adds data to an Access DB. When an employee adds a record I want to compare the phone number from the data they inputted to all of the phone numbers that are currently in the database for that field.
If the new phone number currently matches any record in the DB I want to have an alert that notifies the employee that a record with that phone number exists with the date that the first record was inputted and ask whether they want to continue and add the the new record or cancel the addition of the new record. Otherwise, I want the data to just be added. At this point I have a Case statement that will add the record after a submit button click.
i am trying to create a html form which you can enter the course data into the form and it will add it to the database, but i want the form so when you select the course name from the dropdown box it automatically finds the id from a different table which the id is specified as an autonumber. the tables i have are courses_data with all the data in and course_title which hold the course titles and thier unique ids.
View Replies View RelatedI currently have a web page that pulls in job vacancies from a search form all written in asp and the database is in access. I will be placing an extra field which will say "apply now" and on selecting this you will be taken to a new page where you can fill in your details and email them to the employer.
My problem is I need to know how to get a field in the form that will automatically fill in the title of the vacancy being applied for from the database.
I'm trying to pass a hidden parameter from a form and when the data contains a (') or ("), it bombs. How can I remove the quotes if they exist in the data before passing the parameter?
View Replies View RelatedI use dreamweaver and i have a combobox named country and a text field named email. I want the user choose a country from the combobox and the email for this country go to a text field. Lets say the user choose England from the combobox and an email will be puted in text box. I use PHP or ASP. This is my form:
<td><select name="country" id="country">
<option>1</option>
<option>2</option> </select>
<input name="email" type="text" id="email" value="email for the country in combo box"> </td>
I have a hyper link field in access 2003. when I present the information in my form(after retrieving it from a recordset) the link appears like this:
c#http://c#
even though the actual field in the database contains only the letter "c". this is the same for every value I insert in the field..
What i am trying to do is Update data in a table with data in another table but i want to update 2 fields in the destination table with data from 1 field in another table.
These are the table i have and their fields:
*CUPFirstRound* - Table1
GameId
GameDate
Home
Away
HomeScore
AwayScore
Winner
There are 8 rows in this table, thereofre the GameID's go from 1 to 8 Code:
I have an asp page that shows dynamic data from the db, I only want to show
the first 3 letters / digits from the db on the ASP page.
I get a "data type mismatch error". I assume it is because this is a number, but I don't know what to change.
<%
dim cnStr
dim rcSet
dim frmSSN
dim sqlStr
'store form input into variables
frmSSN = Request.Form("SSN")
'create connection and recordset objects
Set cnStr = Server.CreateObject("ADODB.Connection")
Set rcSet = Server.CreateObject("ADODB.Recordset")
' defining database connection (connectionstring2.inc)
cnStr.ConnectionString = path
cnStr.Provider = provider
cnStr.open
%>
<%
SQL_query = "SELECT * FROM Orders WHERE Driver = '" & frmSSN & "'"
Set RS = cnStr.Execute(SQL_query)
WHILE NOT RS.EOF
%>
I need a way of putting say 10 to 20 bullet points in one table field in an
Access database
- say seperate them with a special character, then build a bulletted list on
my page.
If I can get the page to detect each special character, insert a new bullet
and move on to the next occurance in the string... Code:
Is there away to write data from a database field into a text file on the server.
The data would be more than one line.....