Multi-field Database "order By"

Is it possible to retrieve data with ASP sorted on 2 fields? I've tried :

SELECT * FROM [TableName] ORDER By Field1 AND Field 2

But it gives an error. I've searched the internet on this topic to no avail.
Is it possible?

View Replies


ADVERTISEMENT

Order From Multi Select

Will the Request.form show the correct order that they were displyed in or
will it do something different. I have been testing and it always shows the
order they were displayed.Is this just coincidental?

View Replies View Related

How To Save Multi-name Into One Field, And Display Only One

From my system, it allow product has multi-category, so I need to save
all category names which one product belong to into one field on a
database,

and record saved like " nameA|nameB|nameC " - seperate by "|".

question 1:

the second time when i update the record for same product name, how to
have a record
like "nameA|nameB"

After multi-category name saved, then, i would like to generate a
navigate name with the link like

home > nameB > name of product

question2:

so how can i retrieved only one name from category field.

View Replies View Related

Form Field Order

I know that the order of from fields from a form post are somewhat random. But, what about fields that have the same name -

<input type="text" name="something" value=""> First Choice
<input type="text" name="something" value=""> Second Choice
<input type="text" name="something" value=""> Third Choice
<input type="text" name="something" value=""> Fourth Choice

First = "bananna"
Second = "orange"
Third = ""
Fourth = "apple"

Will the values, in the delimited list contained in Request.Form("something"), always be in the order they are in the form? That is - bananna, orange, , apple

View Replies View Related

Field Order For Adding To Tables

if the order of the fields in a query matters when querying a table with asp. that is, if the table has columns labeled "RecordID, FirstName, Initial, LastName, etc" in that order, do i have to do my "INSERT INTO" command with the fields in that same order, or could i do "FirstName, RecordID, LastName, Initial, etc" ? i think it doesnt matter. am i right?

View Replies View Related

Form Field Submit Order

I have a form with stacks of fields. This is submitted to a formmail.asp script at my isp which emails the values in the form to me.

Is there anyway using dreamweaver that I can define the order of the form fields when they are submitted to me via email? I eventually add the values in the form to a bit of paper, it would be handy if the email could have them listed in the order they are printed on on the bit of paper.

View Replies View Related

Multi Database Connection

I have written a asp application whihc uses a number of pages and each page connects to a sql database.
Currently I have the connection script coded on each page however if i need to change the database I have to change every page.
I have been told there is a way to have the connection on one page and each page to referance this one so I only need to change the one page

View Replies View Related

Multi-Relational Database

I have a table (Software Table) in a database that is linked with a many to one relation to another table (Computer Table). I wrote a simple ASP page to return the records for the software table which shares a one to many realtion with the Computer Table.

One (Software Table) to Many (Computer Table)

At persent the only records that are returned are the ones from the software table. Is there some way to return or display the many computers (one to many) for each record.I cant think how to start to do this. Can I link to computer table and have a drop down that lists the many computers?a better way to display this information?

View Replies View Related

Using Vbscript "SPLIT" Function On Multi-select Field

I am trying to split a mgrgroup field to extract the MD codes. It correctly grabs the MD codes if all records in a mass update are updated, but if only one record in the loop is updated then it puts the last 5 digits of the mgr name in the MD field.

THIS IS THE CODE: ....

View Replies View Related

Using Vbscript "SPLIT" Function On Multi-select Field

I am using the following code to split/join values in a multi-select field. It is combining all the values in All the records into one long string in each record in recordset.

Example: I have a recordset with 2 records. The 1st contains the split/joined values: Alan Smir, Jeff Karl The 2nd contains the value: Keith Robb

When it updates database, it will put Alan Smir, Jeff Karl, Keith Robb into each record in the recordset. Instead it should be putting Alan Smir, Jeff Karl into the 1st record
and Keith Robb into the 2nd record in the recordset.

Does anyone see what is wrong with the code ....

View Replies View Related

Displaying A Database In A Order

I need to know how to display a new post above an old one:

here is my script to display the database (news):

Code:

<%@ Language=VBScript %>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("database/news.mdb")
Conn.Open
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "SELECT * from news", Conn, 1,3
do while not rs.EOF
Response.Write rs("name") & "&nbsp;" & rs("when") & "<br>" & rs("news") & "<p>"
rs.MoveNext
loop
set Rs = nothing
set Conn = nothing
%>

View Replies View Related

Field In A Database

I'm trying to upload the entire field for every recordset to &nbsp;. How could I do this? Here's what I got so far.

<!--#include file="searchconn.asp"-->
<%
UPDATE SearchTable SET SearchTable.newscontent = "&nbsp;";
%>

View Replies View Related

Access Database Field Name

I have an access database with year designations for field names, such 2005 2004 2003 ... and data corresponding thereto. I can formulate a query in MSAccess and it works just fine. However, I am trying to create a web page that will create a database
connection and use SQL to create a recordset(s) which I can then manipulate in vbScript.

The problem seems to be structuring a query that will work in
vbScript. I have tried several combinations:

rs2.Open "SELECT 2005,2004,2003 FROM Table", conn, adOpenStatic, adLockOptimistic
rs2.Open "SELECT '2005','2004','2003' FROM Table", conn, adOpenStatic, adLockOptimistic
rs2.Open "SELECT "2005","2004","2003" FROM Table", conn, adOpenStatic, adLockOptimistic

but none of these will extract data.

I have also tried casting these numbers to strings in a string variable, but still no success.

Is there some naming convention I am violating by simply using year designations as field names or is there a problem with vbScript?

View Replies View Related

Database Field Types

I pass a table name into my program dynamically. I could display the data by looping through the object.Fields for both the field name and the field data using object.GetRows.
What I have not figured out is if there is a way to figure out from the Fields what type of field (ie. Numeric, Text) it is.
Certainly I could check the actual data once it is read, but is there a way to figure out the field type without doing that? Perhaps an object property of a recordset that I am not familiar with?

View Replies View Related

Ref Database Field Name With Variable

I have an asp page that has a function that connects to an Access database.
I am using Javascript. Is there any way to reference the field name in the
database through a variable in a sql statement? Code:

View Replies View Related

Database Field Names

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")%>

View Replies View Related

ASP If Database Field Blank - Do Nothing!

what i am trying to do is when the database field is empty to not display the box (table) that is in my css file, whereas when there's something in the field i would like the box to display!!! So i'm basically trying to get a 'when field empy, do nothing!!! my code at present generates the box no matter whether the field is full or not!!! Code:

View Replies View Related

Update A Field In A Database

I'm having a spot of trouble trying to update fields in a access database using asp. I can delete and add fields thru the asp page but when i attempt to modify the fields i get a page not found error message. Code:

View Replies View Related

Increasing The Value Of A Database Field

im trying to increase the value of an id key in my database by 1 each time i add a new record. is ther anyway i can do it using ASP?

View Replies View Related

Searching Database Field

I want to search 2 of my database fields (title and description) for search terms entered in a form. I can do a 'LIKE' but how do I cover searching for each word in the string that has been submitted? For example, if someone searches for 'World Cup Final', I want to search both database fields for 'world', 'cup' and 'final'.

View Replies View Related

Checking A Database Field

I have a form that inserts a student's course choices into an Access db. The student can choose from 4 options in a day. From a drop down box that is populated from the db.
Each course has a field called count1, count2, count3 and count4 which are the class sizes for those sessions. When they choose a session, I have a bit of ASP that takes '1' away from the count.

However, I need to validate the form when it is submitted so that if course = 0 a message pops up to say the course in that session is full. At the moment, the drop down boxes are populated by SQL that says only show if count>0 but if a lot of students load the page at the same time they can all subscribe to it - so I am getting -4 in some sessions. I need to check whether the course in that option is full i.e. '0' when the form is validated and then for it to tell them that that particular session is full.

View Replies View Related

Parse A Database Field

I am trying to take a name that is in a database field and rearrange it to place it in a session variable. For example:

Database Field:

SMITH, JOHN

What I would like to see:

JOHN SMITH

Instead of - Welcome SMITH, JOHN
I would prefer - Welcome JOHN SMITH

Can this be done when requesting a form variable or does it have to be done when viewing the recordset variable.

View Replies View Related

Determining If A Field In A Database Is Empty Using ASP

I am trying to determine if a field in a database is empty or not. The code I have is this....

(before this I have code that opens up the database, gets the data from the table. the var "content" holds the data if any from the database.)

if content = "" then
alert1 = "content field is empty"
else
alert1 = "content field contains text"
end if

This doesn't seem to work. I also tried...
if (content) then
alert1 = "content field is empty"
else
alert1 = "content field contains text"
end if

No luck yet. Any ideas?

View Replies View Related

Date/Time Database Field

I'm trying to post a value from a form field into a database field of type Date/Time formated to short date.

Even though the value from the form comes in short date style ie 19/06/2004 I'm getting a type mismatch error

View Replies View Related

Inserting Data Into Bit Field In An Sql Database

I 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.

View Replies View Related

Database - Strange Behaviour Of One Field

I have an access database with lots of fields including a memo field called
'priecinfo'.

Everything works well, lots of data is written, but in one particular
situation, I can't get the field 'priceinfo' to write out:

1) the code below works properly except that the field 'priceinfo' doesn't
get written - replace it with any other field and it works. Code:

View Replies View Related

Calling A Database Field From Form

I have the following line of code that is part of a form that displays a record from a database;

<textarea name="name" cols="60" rows="20" value="<% =rscms_example("body") %>" </textarea>

Could you please tell me where I am going wrong on it? I know its probably very simple, but I am terrible at forms anyway.

View Replies View Related

Inserting Value From List Box Into Database Field

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 Related

Validate Form Field Against SQL Database

I need to validate an item number from a form field against a MS SQL database

I am using a 2 page process to print barcodes from an entered item number on page 1 and need to only use valid item numbers from the database. If they enter a wrong number I want to give them a page telling them of the error.

I have 32 fields on page 1 to enter 32 items.(one for every label on the second page that contains the barcodes. Here is the connection to the database that I am using for the barcode.(Column IMLITM contains the item numbers) Code:

View Replies View Related

Update Database Field Read Only

Trying to update 2 fields. my database is read only..

Microsoft JET Database Engine error '80040e09'

Cannot update. Database or object is read-only.

/sendd.asp, line 16

this is line 16: rsAddComments.AddNew

is this something to do with my server directory permissions?

code .....

View Replies View Related

Form Field Data From Database

I 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.

View Replies View Related

Formatting Date Field From Access Database

I am pulling legislation information and expiry dates from an access database and posting to the web. The expiry dates in access are formatted as Month Day, Year (EG.. January 1, 2006) But when they are pulled from the database to the web, they come out as 01/01/06. I know that the format we have in access is simply a mask, however we require that format be carried through.

This is likely a simple solution, however I am new to ASP and can't seem to locate any information on this. I have searched the forum for related info on this but can't find anything that relates to my specific situation.

Here's the code we are using so far...

Code:

<%
Do While NOT Recordset.Eof 'i.e. carry on looping through while there are records
Response.write "<tr><td>"'open row and first cell
Response.write Recordset("Legislation")
Response.write "</td>"'close first cell
Response.write "<td>"'open second cell
Response.write Recordset("Repealed")
Response.write "&nbsp;"
Response.write Recordset("Expiry_Date")
Response.write "</td></tr>" 'close row
Recordset.MoveNext 'move on to the next record
Loop
%>

I have also found and implemented the following code:

Code:

dt=recordset("Expiry_date")
dt=Month(dt)&"/"&day(dt)&"/"&year(dt)
response.write(dt)


This lets me change the positions of the numbers, but I can't figure out how to make it display the full month name and full year.

View Replies View Related

Is It Possible To Insert All Checkbox Values Into 1 Field In The SQL Database?

Is it possible to insert more than 2 checkbox values into 1 field in the SQL database?

I have 5 checkboxes; I would like to insert them all into 1 column in the SQL DB.
If I insert more than 2, it gives an error.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved