Selecting Tables From A Drop Down Box

i have a drop down box that selects tables on my asp page, but using the hidden attribute, they have fixed positions on the screen. this a search engine and i need it so that if they only search two options that them two options will be at the top of the screen?

View Replies


ADVERTISEMENT

Selecting Tables From A Drop Down Box With No Fixed Position On Screen?

i am designing a search engine, you select the search options from five choices in a drop down box, each option reveals a table, but the tables have fixed positions on the html page.

i need it so that if only one option is picked to search and it is the last option on the drop down list, that it will appear at the top of the page? i dont have a clue what type of function to write to do this or what techniques will be involved!

View Replies View Related

Selecting 2 Access Tables

Select data from 2 tables at the same time but there is no relationship between them. This is what i want but i dont know how to join them.Here is what i was trying.Code:

sqlstr = "SELECT * FROM persinfo,positions WHERE personid.personid = '"& session("personid") &"'"
rs.Open sqlstr,conn,0,2

sqlstr1 = "SELECT * FROM positions WHERE jobidid = '"& session("jobid") &"'"
rs.Open sqlstr1,conn,0,2

View Replies View Related

Selecting Drop Down Options

I am trying to set up a component that will allow events that are date sensitive. From this date to that date. What I am trying to do is use drop down menus for selecting the dates, and I am having a hard time finding out how to build these drop downs so when someone is editing an event, the existing dates are pre-selected in the drop downs. But I need to seperate year, month and day for both and then have it change the value of the correct option to selected.What is the easiest way to do this?

View Replies View Related

Selecting Multiple Tables Using SELECT Statment Problem

I am Trying to use the SQL SELECT Statment to open records from multiple tables into one recordset.

I know the basic syntax of the Select statment but I wanted to know if its possible to recive the table name from the feild or the record that I am readinf from the recordset in any given moment.

To make things more clear, my example:

-Open a connection

SQL = "SELECT * FROM TABLE1,TABLE2 WHERE TABLE1.UserID=" & uid & " And TABLE2.UserID=" & uid

rs.open sql,conn,3,3

while not rs.EOF

-read from record

rs.movenext
wend
rs.close
conn.close

now, in the part that I read from the record, is their any way I can know if that record is from table1 or table2?

View Replies View Related

Drop Tables

I'd like to know if there exists a query to erase/drop tables from an access table (on a asp script) older than X creation date.

View Replies View Related

Filter 2nd Drop Down List Value From DIFFERENT Tables

I have coded 2 drop down lists. For ur info, currently my 2nd drop down list's content is being retrieved from one single table in database only. What if I would like to make the content of my 2nd drop down list to be populated with data from 2 different tables?

What i mean here is that, the selected value in 1st drop down list will determine data from which table to be loaded into the 2nd drop down list. Earlier I'ved coded my SQL statement as:

SQL = "SELECT x.language_ID, x.language_name, y.msg_category " &_
"FROM Language x INNER JOIN outMessageENContent y " &_
"ON x.language_ID = y.language_ID"

where data for 1st drop down list is loaded from table x and data for 2nd drop down list is loaded from table y.

My 1st drop down list only has 2 values., which are 'English' and 'Chinese'.Now I would like to make it as, if user select 'English', then my 2nd drop down list will refer to that particular 'English' table, while selecting 'Chinese' will allow 'Chinese' table's data to be loaded into my 2nd drop down list.

So what shall I change in order to filter the 2nd drop down list's content according to the selection from 1st drop down list? Shall I modify my SQL statements?

View Replies View Related

Drop Tables By Creation Date

if there exists a query to erase/drop tables from an access table (on a asp script) older than X creation date.

View Replies View Related

How To Populate "chapter" Table Fieldname (MSAccess 2000) By Selecting Book From Drop

I have 2 dropdowns (or listboxes). 1 is for list of books called "book_title". I use a different recordType for value. Code:

View Replies View Related

Creating Dynamic Tables In Dreamweaver To Display Tables

I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.

View Replies View Related

Display Drop Down Options Based On The Selected Item From Another Drop Down

The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:

View Replies View Related

Selecting Info

I've got a WYSIWYG editor, that runs off a template page (i.e. template.htm) that gets opened in an iFrame for editing.
How can I get it setup so I cange the template at the click of a button? I've tried doing a form with radio buttons, but can't get it to work.
For example, the iframe source has been set to "strTemplate". My form processing was along the lines of:

<%
If request.form "template" = "template1" then
strTemplate = "template1.htm"
Else
strTemplate = "template.htm"

If request.form "template" = "template2" then
strTemplate = "template2.htm"
Else
strTemplate = "template.htm"

End If
End If
%>

View Replies View Related

Selecting A Value From The List Box

I have a list box which has the following values:

Car
bike and Boat

If I select "car" it is fine but when I select "bike and boat" it just takes bike
as the selection. It is taking the space as the end of the string. Is there a way I can
rectify this?

View Replies View Related

Selecting Dropdown In ASP

My boss wanted me to add a dropdown to this form. I was able to add in the dropdown and it inserts into my database (Access) just fine. However, I have an edit page also and this is where my trouble comes in.

On the edit page, the dropdown does not "know" which specific option was selected. I tried to write an If statement but I think there is something wrong in my syntax. Code:

View Replies View Related

Selecting Software

I have undertaken a website revision project after not programming for about 6 years. I am beginning to set up a work environment on my pc, and have questions about the software being used verses what could be the ideal software.

I am familiar with classic asp pages, not asp.net. I am also familiar MS Interdev (but am unable to locate my copy and cannot find a torrent file - is this an archaic program now?). The last thing that I'll mentioned is that I prefer to have a debugging capabilities.So the current website uses Dreamweaver 8.0, IIS 6.0, and MSSQL 2000. Question.Given my background, what software would you use to set up a work station?

View Replies View Related

Selecting Values

i need to display results that do not match those in the database.I have an excel file and i upload it,inserting the records in a temp table. han i compare the values in the original table and the temp table.All i want is the values that do not match

sql = "SELECT TempSerial.SerialNo "&_
"FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
"OrderBY TempSerial.SerialNo;"
Set RS = objConn.Execute(sql)

i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.

View Replies View Related

Selecting Last Record

i need to extract some data from a table called accountantsBids. I want to select the last entry for every accountant based on the date descending.

Table:
entryid = Autonumber
Accountantid = FK
DatePosted

I've tried TOP 1 but that doesn't do it - it only gives one recordset. What would be the best way to get this working.

View Replies View Related

Selecting * After Date()

I have a database with date of gigs in it and am trying to select * from the database the next gig basically, and am compariung against todays date and saying select * more than todays date. Is this right, cause it's not doing it? Code:

dateN = Date()
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "************"
set recsetS= server.createobject("ADODB.Recordset")
sql = "select * from admin where dated > "& dateN &" order by relevance DESC "
recsetS.open sql,conn,3,3

View Replies View Related

Selecting All Checkboxes Using ASP

I created a form for Deleting multiple records (from Access db )using checkboxes. However, I would like to add a link or button that would check mark all the checkboxes since I could have hundreds of records.

What is the best way to go about it. Does anyone knows of any samples other than Javascript.

View Replies View Related

ASP & XML - Selecting Last Node??

I was wondering if anyone has a moment to look over some code I've written?

I'm involved in the maintenance of an old CMS system I wrote a number of years ago, when I was regularly coding in ASP. These days it takes a while to mobilise the grey matter when it comes to ASP.

Anyhow, basically I am trying to select a specific node and determine the id of the last child of the parent node.

At the moment, I am only returning the first childs id, despite my best efforts. Code:

View Replies View Related

Selecting Ranges

On the online crm system i've built (using ASP) our customers can create a list of contacts and download/delete/add to this list when they want to and then go and view the list. It will display 20 on a page with forward/back buttons etc.

I have written a routine which queries the MS SQL 2000 database and retrieves all the IDs of the contacts. It will then work out the page it is on and display the appropriate records by reading through the 20 IDs for that page and query the data from each ID it needs to display on the screen.

This works fine for lists of up to 1000-2000 but when it gets to 5000, 10000 records it becomes an issue of performance as it will hold in a variable all of those 5000 or 10000 IDs. There has to be another way of doing this.

View Replies View Related

Selecting Count(distinct Value)

I want to select just one field to display using sql and I want to have another variable that counts how many fields of the same value there are. My code looks something like this but i'm getting an error...

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal. Code:

View Replies View Related

Selecting Random Images

Is it possible to select random images from a directory without creating a "library"

As in I want to have a directory with 25 or so images and want to randomly select an image without having to change the txt document when I add new images.

View Replies View Related

Selecting Which Page To View .ASP.

This is my page that displays a certain players games played below. It sorts by games played and excludes all records that = 0. Now with 9 different grades to show i did not want 9 different pages, so i added in 'strSortGames' so that they can select which grade to view and only one page is needed.

I used a menu (list field) on a previous page to do this, do you no a better way to do this? e.g Text links or some other way? or is a list field a fairly good way? Code:

View Replies View Related

Selecting DB Results Where First Letter = ?

What query would I have to use to select entries from a database where there first letter is a letter of the alphabet? ie. Select all entries starting with an A etc.

View Replies View Related

Selecting Distinct Intervals

I need help programming a search function. I want to narrow down a search function regarding time. I figure the best way to do this is to select a higher interval and a lower interval, and then have an sql function that grabs the times from within that range.Code:

sql = "SELECT DISTINCT place, time FROM bussystem WHERE time >= '"&timey&"'"
Set rscurrent = Server.CreateObject("ADODB.Recordset")
rscurrent.Open sql, conn, 3, 3

sql = "SELECT DISTINCT place, time FROM bussystem WHERE time <= '"&timey&"'"
Set rsrecent = Server.CreateObject("ADODB.Recordset")
rsrecent.Open sql, conn, 3, 3

View Replies View Related

Selecting All12 Months

Is it possible to select all twelve months in one select query either from a single field name or through an alias name?
I have a field name that conatins dates, and I would like to arrange the value of each month in a grid, jan-dec, monday-saturday. can I accomplish this with one select statement using an access db?

View Replies View Related

Inserting And Selecting Image From DB

I need Help in inserting the user image in my data base. but
unfortunatly I don't know how.I'm using asp with sql server. I tried to
insert the image and i geuss it worked.for the field in the db in not
null and it have this value <Binary> . but when i try to select it in
gives me this error "An unhandled data type was encountered".
this is my code :

View Replies View Related

Selecting Values That Do Not Match

hi there i need to display results that do not match those in the database. I have an excel file and i upload it, inserting the records in a temp table. Than i compare the values in the original table and the temp table. All i want is the values that do not match..i did this:Code:

sql = "SELECT TempSerial.SerialNo "&_
"FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
"OrderBY TempSerial.SerialNo;"
Set RS = objConn.Execute(sql)

i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.

View Replies View Related

Selecting Random Records

i want to select some records from my database by random. i want also to set a limit (limit=9).

View Replies View Related

Selecting Correct Details

Im trying to make a client area on my website and an not sure on how to go about editing clients details.When the client logs in they are brought to a menu where they can update there record. How can i get the appropriate record from the database so they can update there details?

View Replies View Related

Selecting Random Rows

I've got an application I'm working on that will be used to generate and track the results of a computer based test. What my boss want's to do is have a repository of questions. Have some questions coded so they are always asked, and the remainder of the test come from randomly selected questions.

I'm having trouble figuring out how to pull random rows from a table and make sure that that they haven't already been selected.

View Replies View Related

Selecting Part Of A String

I'm just starting out learning a bit of asp with my job so pardon my bad use of any jargon

In 'A:B:C: D:E' I want it to only return 'A:B:C: D'. Dropping off the content after and including the LAST :

Can anyone help?

View Replies View Related







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