2 Record Sets

Is it possible to have an ASP form where there are 2 form fields, each mapped to a separate Access Table? Say for example

Dim rsOne
Dim rsTwo

rsOne mapped to tblOne in Access File Mydb.mdb
rsTwo mapped to tblTwo in Access File Mydb.mdb

View Replies


ADVERTISEMENT

Record Sets

Is there a way for me to determing if a column exists in the table? ex. I
have RS("var"), where RS is a recordset. My code is dynamic but some tables
will have "var" while some won't.

View Replies View Related

Comparing Two Record Sets

how can i compare 2 record sets. In one RS i have excel file and other RS i have SQL server and when i get the results from both i want to compare them as one of you guys suggested me to write a loop that cycles through the record sets Comparing any fields.

View Replies View Related

Comparing Record Sets To Cookies

What would be the most efficient way to check to see if a cookie matches a record in a DB table?

If the user's cookie matches a record in a table of executives, then I want to display a breadcrumb menu item just for that executive.
This does not have to be super-secure or anything, I just want to keep honest people honest.

If the information they submit in a cookie is also present in a table of executives, then I want them to see a comprehensive menu set. If they are not in the table, then I want them to see a reduced menu set.

How to go about comparing a cookie with multiple values or keys with a record in a table?

View Replies View Related

Record Sets - Selecting All Results

im a passing 3 fields from a form to use a search criteria against an access database table, i have set the fields a numeric values, what should i use to allow all records to be shown for a invidual value rather than a selected value.

Ie the form would pass

Location_id as 22

so the result page would see Request.form("Location_id")

sql would then see

where location_id = var1

var = 22

but i want to get the sql to say

where location_id >=0

what do i need to do

View Replies View Related

Use Value In Query String To Produce Multiple Record Sets

I have taken over a website that was done in Frontpage and I am trying to move away from it. I am having problems with page 1 where I have a link that passes a single value to page 2 in the query string.

On page 2 I want to use that value in the query string to produce mulitple record sets. This actually works when using the fpblib.inc. Is there a way of doing this without having to use Frontpage coding.

View Replies View Related

Javascript Language Paging Larger Database Record Sets

I am fimliar with asp javascript and not asp VB.

i can display the results ok, but if i return 100 records from my table i would like it to display 5 records per page. i have looked at asp recordset paging on several sites, however cannot find any scripts that work with ASP JAVASCRIPT....

View Replies View Related

Joining 2 Result Sets

i want to left join result sets together coming from two different databases based on a common field storenumber. They are separate databases as per management design.

Basically it should match rows based on the store number, those who don't have matches should display only the storenumber and no other info like: Code:

Store Q1 Q2 Q3 Q4
1 x x x x
2 x x x x
3 <--No data in 3, just display storenumber
4 x x x x

View Replies View Related

Passing Multiple Sets Of Variables Into SQL

Before I created this thread, I've searched Google and used the search feature of this forum numerous times on how to do this, but couldn't find much.

Basically, I'm trying to pass multiple sets of values from the search form to the ASP into an SQL statement (Access Database).

I can only make it display different prices of a certain music type, eg all prices of rock. But it doesn't output all types of music for certain prices, eg viewing Classic and Rock records with prices of 8.99 and 10.99 only.

I've used the REPLACE command I've found and got around that problem of syntax with numeric/alpha data. Code:

View Replies View Related

Replacing 1 Set Of Double Quotes With 2 Sets

How can I replace 1 set of double quotes (") with 2 sets ("")
I tried this but it didn't work: myText = replace(myText,""","""")

View Replies View Related

Code Pages, Cookies & Character Sets

I'm a little perplexed. <%@Codepage="65001" %> changes how IIS/ASP will handle interpreting query string variables - i.e. it will read the querystring as being utf-8 encoded.

However, I'm finding that it *doesn't* change how Response.Cookies or
Request.Cookies get read/written.

I've been testing with a little jscript asp page with the lines

if (String (Request.QueryString ("abc")) != "undefined")
Response.Cookies("abc") = Request.QueryString ("abc");
Response.Write (Request.QueryString ("abc"));

to take a value from the query string and pass it back out as a cookie. The test value I was using was r%c3%a9sume (resume with an accented e). When the code page is set to utf-8, it will properly interpret the urlencoded query as a utf-8 string. It will output the right bytes with Response.Write.

But watching the headers produced by the request, it comes out encoded in latin-1.
Set-Cookie: abc=r%E9sume; path=/

I checked the cookie rfc on w3c.org, and oddly it doesn't say much about how to encode/interpret cookie NAME=VALUEs. The only comment on character set in the spec is that a cookie *comment* has to be utf-8 encoded.

I couldn't find anything on the MSDN documentation that addressed cookie character sets either.

View Replies View Related

Displaying French Canadian Character Sets

I have an ASP page that displays data from a SQL database. It includes some Canadian names/address which contain the special accent characters...my ASP page doesn't display them properly. I have included the tag

<META HTTP-EQUIV="content-type" CONTENT="text/html; charset=ISO-8859-1">

but they don't show up correctly...what else do I need?

Update: Turns out the source of our data gave us the old IBM codes, not the newer codes...for example, they gave us 144 instead of 201, and using the charset of 8859-1 won't allow 144 to be displayed. When replaced with 201, the character displays just fine.

View Replies View Related

Drop Down Selection On Intranet Sets Default Value In Database

I'm working on a project, trying to create an HR hiring intranet page. Basically, here is problem. I have a table in a database called "Title Access" that lists titles, and has software, email, and user rights associated with each title. For example, Network Administrator will get Office, Dreamweaver, be part of the IT and Admin groups.

Now, here is the issue: Whenever the user types in the name, pay rate, hire date, and title on the intranet page then clicks "submit", I want the database to create a new user in the "employee" table with that name, and populate the access rights in that table with the rights associated with the title. Thus, the "employee" table will now include "John Doe", and will have Office, Dreamweaver, IT, Admin checked off. Is there any way to do this????????????

View Replies View Related

0x80004005 Error, Cannot Add Or Change A Record Because A Related Record Is...

I'm getting this error message: Error Type:

Microsoft JET Database Engine (0x80004005)

You cannot add or change a record because a related record is required in table 'employees'. Code:

View Replies View Related

Insert Record Goto Last Record

I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?

View Replies View Related

Record Numbers Against Record Problem...

I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.

Ship Date: 04/06/04

Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx

Ship Date: 11/07/04

Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx

What I want is:

Ship Date: 04/06/04

1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx

Ship Date: 11/07/04

1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx

How can I get these numbers printed againsts the records ?

View Replies View Related

Record Set

I want to download record set from my SQL database as csv format but in ZIP file .I can download as a csv file now ..But i can't put that in zip file and download.

View Replies View Related

Record

how to deal with multiple recordsets on the same page?
It's gotta be something small and clear so I could understand.
Somewhere I've read that multiple recordsets are not allowed when using Microsoft Access Database?

View Replies View Related

Set Record

I am looking to
have some sort of SQL Trigger maybe? I have a field called 'dateActivated' and 'isActive'I'm looking to somehow say when dateActivated + 6 months then set isActive = false. I want this to
be automatic. I am using ASP/VBScript if this somehow matters.

View Replies View Related

Add More Than 1 Record At Once ?

I have a form on an asp page which is used to add additional users to
the DB, i.e. adding a UserID (PK on table), Password & Email.

The companies are allowed a max of 3 users. If the company only has
the default 1 user and wishes to add another 1 or 2, then the form
displays the current user details, not in text boxes as this is not an
adit data form. The additional user/s can be entered into 1/2 rows of
text boxes, user 2 & 3.

If they decide to add 2 new users, how do I add the additional 2
records to my db table on submit ? Code:

View Replies View Related

Record Set

i am tryin to run a search on a db and am using a like statement which works fine but i want to select what it finds and also the next 9 records any idea on how to do this

View Replies View Related

Second Last Record?

Is there any way to change the following code so that when it's the second last record in the set it doesn't put UNION ALL at the end? Basically, is there a way of saying:

if SecondLastRecord then

I don't know how many records there will be, so I can't count down from 7 or anything.

Code:

View Replies View Related

Add New Record From Asp To Sql

Every time I try to ADD a new record from my asp page to SQL table, I got this error:

Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Violation of PRIMARY KEY constraint 'PK_Cancelled_Classes'. Cannot insert duplicate key in object 'Cancelled_Classes'

Here is the Insert statement:

Sql="INSERT INTO Cancelled_Classes (yrtr, cou_id, cancell_date, Message)" sql=sql & " VALUES " sql=sql & "('" & Request.Form("yrtr") & "'," sql=sql & "'" & Request.Form("cou_id") & "'," sql=sql & "'" & Request.Form("cancell_date") & "'," sql=sql & "'" & Request.Form("note") & "')" '

conData.Execute sql

View Replies View Related

Record Set

I had a problem that happen once only but i do not want it to repeat
again. It happen when i retrieve data from my database. The process
can't complete and show error 14, Out of string space. I suspect the
recordset object had reach it limit that why it generate that error
message but what can i do to prevent this from happening

View Replies View Related

Add New Record

I have a siple script where I add a new row in a table which has also a autonumber field. Adding the new row I am trying to get this value of the autonumber field and put it in session, but can not seem to figure out how. I tryed to open a new recordset and pull it out but does not find the record I just added.

View Replies View Related

Record Set In My Sql

The only database connection I have ever made using ASP is to an SQL2000 Server. I was just wondering if someone could provide me with a nice simple script opening a connection and recordset to a MySQL database and providing a valid connection string.

View Replies View Related

Add Record

Trying to learn a little asp and am trying to have my form (when the submit button is pressed) put the value in a field in my database. it worked the first time, I typed in the word testing and clicked submit.

now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here. Code:

If Request("submit")="Submit Questions" Then
Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')")
End If

View Replies View Related

Record Is The First In A Record Set

I'm looping through a record set and want to treat the first record differently. I've got a counter that I check to determine if its the first iteration through the loop, but I was wondering if there is recordset property that would indicate the record's position in the record set.

View Replies View Related

Get Record From Db

now i got all my data in my sql db table (fsearch) . now i want to take the value from the db to display it on the browser in the form of a table .

View Replies View Related

Using Record Set Twice

i need to use the same record set in my page twice. some optimization issue [img]images/smilies/biggrin.gif[/img][img]images/smilies/biggrin.gif[/img]. i have arecord set like this

Code:

set newsrs=createOBject("ADODB.recordSet" )
newsrs.Open newssql,cnn,3,3
and i wanna use this twice in the same page
Code:
do while not newsrs.eof
newsrs.movenext
loop
can any body tell me how? coz when i do it the second isnot working [img]images/smilies/rolleyes.gif[/img]

View Replies View Related

Using One Value From A Record Set

I run a query like

SQLSelect ="Select Number,Type,Description,Retainage_Percent from table_name1"

this returns a value for number. then I would like to run another query on another db

SQLSelect2 ="Select Number, Text from table_name2 where table_name2.Number = table_name1.Number

View Replies View Related

Can't Add Different Record

I didnt know what to title this, so please bear with me. Trying to learn a little asp and am trying to have my form when the submit button is pressed put the value in a field in my database.

it worked the first time, I typed in the word testing and clicked submit. now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here.

Code:

If Request("submit")="Submit Questions" Then
Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')")
End If

View Replies View Related

Querying The First Record

how to locate the first record...i sorted the numbers and i want to display the first record based from the query...

View Replies View Related







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