I need to take two seperate queries and put them in a single html table, but i want to combine the sets of data 'while selecting them' so i can use the SQL sort by command to arrange the whole table by date..
sorting the two queries independantly then dumping them to the table results in both queries being sorted independantly, ie the most recent entry(by date) of the second set of data ends up in th emiddle of the table.. any ideas?
I have this query that isn't working for me. This is a simple phonebook (first name and last name) form. Trying to accept wildcards. Here is the statement as I see it: Code:
Query = "SELECT cn,telephonenumber,mail FROM 'table' WHERE (cn = '" & FName & "' OR cn = '* " & FName & "') AND (cn = '" & LName & "' OR cn = '* " & LName & "')"
But this isn't working. Where am I messing up the syntax?
I have 2 SQL strings:
SELECT *
FROM NK_editie " & MM_whereConst & " " & whereClause & "
ORDER BY editie desc
And
SELECT *
FROM NK_editie INNER JOIN NK_edities ON NK_editie.editieid = NK_edities.ID
ORDER BY editie desc
Now I want to combine those 2 to one string.
I have problems to set it up in working order.
My tryout:
SELECT *
FROM NK_editie INNER JOIN NK_edities ON NK_editie.editieid = NK_edities.ID &
" & MM_whereConst & " " & whereClause & "
ORDER BY editie desc
It shows al the records which are joined, only the second string " & MM_whereConst & " " & whereClause & " is not working.
I've created a web form with multiple textfields for acquiring somes date of birth (i.e. textbox for DD, textbox for MM, textbox for YYYY), now what I'm trying to do is grab the values from these objects and combine into 1 session variable, which later on is inserted into an ACCESS database.How do I append these values together to be one value in a session variable (i.e 23122004). I have a input mask inside the ACCESS database, so it needs to go in this format. I assume once I have captured these 3 fields, I need to convert them to integer, and then merge?
View Replies View RelatedI have a database used by another application, i want to be able to manipulate the data stored in the database, the problem is that the way the information is stored its awkward(assume this is purposely so), but i cannot change the db structure at all, so heres my problem: Each Person in this database will have multiple comments stored against them:
ID | CommentCode | LineNum | ValueData
1234 COMM1 1 Something about thi
1234 COMM1 2 s person seperated ov
1234 COMM1 3 er multiple lines
1234 COMM2 1 Something else about
1234 COMM2 2 them
What i want to do is circle through the recordset and combine the multiple lines of the same comment, any ideas/examples?
It's regarding an ASP FORM for the credit card process:
I'm collecting credit card information on my secured server. When collecting the Month and Year values (for the expiration date of the card) with Select/Option tags, I don't have a way to concatenate them together prior to submitting the form so I can post them in the format the gateway asked me for (e.g. "mmyy" or "mmyyyy")
Do you have a way where I can submitt those variables togehter in such format? Code:
I am trying to edit data from this form in ASp/HTML but because both the field that I am editing is in the text box that has the same name, it is combining the data from both the field and updating in the table. Is there a way I can change the name of the text box progammically?
View Replies View RelatedI'm just about to start a project that needs to combine the results of a SQL
Server query with the results of an Index Server query. The basic idea is
that the user enters/selects a bunch of search criteria on a form.
Most of
the criteria selected by the user will be used to select records from the
database - standard WHERE clause stuff - but the user can also enter
free-text that should be searched for in associated uploaded documents.
The
documents are sitting in the file-system with file-name pointers only stored
in the database (not the document). Only records where the associated
free-text is found in the documents should be returned. I'm new to Index
Server and am wondering how is this done. Any good references/tutes?
Normally I use Access database with ASP, and I create queries using the wizard which Access has. Then, I copy and paste the code in the ASP page and create my SQL.
I was wondering if it is easier to call the query directly with its name from Access, or else continue using the old procedure.
I'm trying to build sql queries that will search through my DB. I am currently seperating my queries through multiple indexes in an array depending on whether or not the strings are wrapped in quotations.
I also want
Fluffy
Teddy
Bear
(three different LIKE statements)
I have the following page which I am using to select 3 diffrent queries but i was wondering if i could just use one SQL statement instead of 3? Code:
View Replies View RelatedSay I have 5 fields in a form. I have figured out how to query a database using all 5 fields and display the records that match at least one of the fields.
I'm trying to figure out a way to, if say the user only fills in two fields, to only search the database for matching records based on just the two fields. As I have it now, the database is searched for the two fields they entered as well as three fields of "", which I would rather not have. Is this possible?
I have a DB. With 1 table called "products" and 3 product records. The 2 fields present in the table are called product_name and product_price. The names of the products are Product1, Product2 and Product3. They cost 13, 8 and 24. Which code (SQL and AP) would generate an output similar to this?
Total is: 45.
Product1 costs 13
Product2 costs 8
Product3 costs 24.
<%
SQL = "Select * FROM products" (plus some kind of sum function to calculate the total (to be able to display the sum before the various products) of the recordset without having to loop through the recordset first)
%>
I need to connect to 2 different databases in ASP and execute two different queries. Please let me know how to proceed. I understand that ADODB.Command option can connect to only one database at a time.
View Replies View RelatedI am running the following code to an access database
' Recordset Object
Dim rs
' connecting to database
con.Open connStr
' executing stored procedure
Set rs = con.Execute ("exec SpotDesc")
' showing all records
While Not rs.EOF
Response.Write rs(0) & " " & rs(1) & "<br>"
rs.MoveNext
Wend
' closing connection and freeing resources
con.Close
Set rs = Nothing
This works and runs the stored procedure SpotDesc.
One question I have is that this line brings back the results
Response.Write rs(0) & " " & rs(1) & "<br>"
but requires me to know how many colums are being returned, ie rs(0) is column 1 and rs(1) is column 2
Is there a way of writing this line and it places all the columns there wheter it be 1, 2, or 3?
Ie a way of know how many columns are returned...
Is there also a way to show the column heading?
I never ever thought about this, but recently I made a query in access so I
can make a customer mailing list based on relational information and it was
so easy to make the query and join tables and assign criterea using access.
And I haven't tried or thought about this cause in my own small asp projects
I've never used a dbase with queries in it, but after seeing how easy it
was, it would save a lot of time from manually writting queries in asp.
So, what I'm asking is if I can use a query from an mdb in asp just like I
can access tables?
This "query2" is used in an MS Access environment.
SELECT T_Perso.*, query1.*
FROM T_Perso LEFT JOIN query1 ON T_Perso.IdPerso = query1.IdPerso;
In SQL, "query1" is :
SELECT T_Items.*, T_Items.IdTypeItem
FROM T_Items
WHERE (((T_Items.IdTypeItem)="Inscription"));
I would like to translate "query2" in full SQL language in order to use it
in ASP but I have some problems with syntax and sub-queries.
I suppose it's quite easy but.I'm a newbie in SQL.
Can I have one recordset execute a Select and then have another recordset execute a different Select, and then check if a field from the first recordset is different from the field in the 2nd recordset and if so write out that row on my displaying table?
View Replies View RelatedI want to define search based on diffrent conditions.The user has the option to select any number of choices.i.e
Condition1.Age
Condituon2.Age & marks
Cindition3.Marks
How do I construct dynamis sql query?
I am using ASP and crystal reports 8.5. I am able to show report from asp. My problem is , I have to show the report based on the sql query that is passed to crystal report from asp. I actually dont know how to pass a query into crystal reports from asp.
View Replies View RelatedI have a single asp page (index.asp) with an include file (include.asp). I would like to query the database with index.asp as well as query it with include.asp.
I searched online, in my "SAMS Teach yourself active server pages 3.0 in 21 days" and it makes no mention of two queries on a single page. Is this even possible?
Is it possible to use an If statement to select a single query from a list of queries from an access db? Something like this:
If Request.Form("Womens") = "Pants" Then
'open the db and run the query called pants
ElseIf Request.Form("Womens") = "Shirts" Then
'open the db and run the query called shirts
'on and on we go, etc.
End if
My gender categories (women, men, etc.) have multiple sub categories (shirts, shoes, skirts, etc.). Does is make sense to use an if statement(assuming it can be done) in this manner? It seems it would make life easier to use one script to perform many tasks, as opposed to one script that does just one task.
the following statement doesn't work, even thoug when I execute SQL_1 and SQL_2 separetlly it works fine.
SQL_1 = "SELECT COUNT(*) AS ACTIVE_LINKS FROM TABLE_LINK WHERE ACTIVE = 1"
SQL_2 = "SELECT COUNT(*) AS UN_LINKS FROM TABLE_LINK WHERE ACTIVE = 0"
SQL = SQL_1 & " UNION " & SQL_2 ...
I know that asp can be used to fire off stored procedures within databases, but I was wondering - does a 'query' in Access mean the same thing as stored procedure? If it does, how could I get asp to fire off that procedure when needed?
View Replies View Relatedas with searching through a mdb table, is it possible to search a query in access?something like...
select * from 'access query' where
Is there a way of inserting the query of records from the first database into the second? Because I want to use the second db by deleting records that might be unnecessary.
View Replies View Relatedbasically, I have the files for this thing, it basically retrieves and displays records from SQL on screen. cool.
Now I want to add further additional fields in that asp file, so ive added labels and textboxes. cool.
How do I tell it to go to the SQL DB and retrieve the data?
Once its done that, how do i take each field that is required and place them in the correct textboxes?
I have a form which accepts the username and password. I am storing it in an Access Database. How do I check if the user already exists in the database by passing SQL queries? Could someone possibly give me the code or maybe a link.
View Replies View Relatedgive me a sample code to display a "please wait"
message while retrieving results from the database in ASP.
i have a text file (tsv) with products in, but i want to run queries on certain fields, e.g. description, i ahve tried linking the txt file to a databse but the recordset does not work,
does anybody have a sample script that will query a tsv, csv file.. e.g.
SELECT FROM prices.tsv
WHERE products = cisco
I have a form submitting a date range in ASP. I want to use them in a query to select from access.I've done similar things with other languages and/or other DBs.
StartOfMonth = Request.QueryString("StartOfMonth")
StartOfNextMonth = dateAdd("m",1,StartOfMonth)
EndOfMonth = dateAdd("d",-1,StartOfNextMonth)
StartOfMonth = CDATE(StartOfMonth)
EndOfMonth = CDATE(EndOfMonth)
sqltext = "SELECT * FROM NewsLetterRequests WHERE CDATE(DateTime) >= " & StartOfMonth & " AND CDATE(DateTime) <= " & EndOfMonth
I currently have a sql query that pulls all records based on a variable(var1) inputed by a user from a form. Each record in my database has a time stamp assoicated with it. I want to give the user the option of pulling all records based on (var1) and allow them to sort based on date or time stamp also with a two fields that will take a range.
(ex. Beginning date and Ending date). So my default sql query will allow for var1 to be inserted and to have all records returned for the current day. BUT, IF A USER HAS ENTERED
A DATE RANGE then all records will be returned for that date range based on the var1's value. How could i go about about structuring my code for this? I was thinking about a "Switch" statement that could response to different user options with different sql queries. What do you guys think?
i have been doing this asp page....but the page doesnt seem to work....it doesnt redirect as i wanted it to be...i dont get any erro message....so idont know wats wrong witht his code:
View Replies View Related