Dynamicly Name A Record Set

I am having trouble generating a name on demand for a record set, would very much appreciate

some help. My objective: generate multiple record sets with different names - mmm seems easy.

I have a commer delimited array of id's I then split the array. For each id I need to write an sql statement, execute it and populate a record set. There is no way of telling how many ids there are going to be so i have: Code:

View Replies


ADVERTISEMENT

Set Dynamicly Request.contentencoding

I'm trying to retreive some information from the querystring. The web site
is as default configure in "utf-8".

But on only one page i need to change dynamicly the contentEncoding to
retreive information send by an ActiveX component in iso-8859-1 format.

Iv' try to put this code in my page :
Request.ContentEncoding = System.Text.Encoding.GetEncoding("iso-8859-1")

But nothing happens.

View Replies View Related

Display Image Dynamicly

I'm trying to display an image which is stored in a database, followed by some other information, but I'm having some issues. It's stored in an access database as an OLE object. The code I've got right now is:

<%
Response.ContentType = "image/gif"
%>

<img src="<%= Response.BinaryWrite(rs("ItemImage")) %>">

The error message I get displayed "The image cannot be displayed because it contains errors"

I also tried it like this:

<%
Response.ContentType = "image/gif"
%>

<img src="<%= rs("ItemImage") %>">

which didn't display any errors, but also didn't display the image.

Any ideas where I'm going wrong with this?

View Replies View Related

How To Create Menu With Sub Menus Dynamicly

I've got a problem with asp.net i am trying to make a menu control. and have
searched the web for serveral controls but they don't work correctly.

I am pretty new to asp.net building. What am i looking for. i am looking for
code to make a dynamical menu with submenus The menu items are stored in a MS
SQL Table and when by loading the page the items will be created. i have made
a asp table. i want my menu on the left cell, in the middle cell i want to
change my pages to the menu item choosen. Code:

View Replies View Related

Random Display Of Images Dynamicly From Database

I am trying to retrieve images from the database and display them in a random order. The order of the images is supposed to change each time page is refreshed.

Below is my code, I am using an array to store the images but the images are not displayed for some reason. Any help would be appreciated.

<% Dim rstResult
Dim strSQL
Dim img(100)
imgID = 0
set rstResult = Server.CreateObject("ADODB.Recordset")
strSQL = "sp_sel_TilesByType 'O'"
rstResult.Open strSQL, strConnect

set rResult = Server.CreateObject("ADODB.Recordset")
sSQL = "sp_sel_TilesByType 'O'"
rResult.Open sSQL, strConnect


if not rResult.EOF then

do while not rResult.EOF
response.write("hi")

imgID = imgID + 1
img(imgID) = "images/tiles/" & rResult("TileImage")
response.write(img(imgID))
rResult.movenext

loop
end if

if not rstResult.EOF then
intVendorID = 0
do while not rstResult.EOF


if intVendorID <> rstResult("VendorID") then
rndNumber = RandomNumber(imgID)
Response.Write "<p>"
Response.Write "<a href=javascript:popWin('tileview.asp?" & rstResult("TileID") & "','',1,1,1,1,700,600);>"
'Response.Write "<img src=images/tiles/" & rstResult("TileImage") & " border=0>"
response.write(rndnumber)
Response.write "<img src=img(rndNumber)>"
Response.Write "</a>"
Response.Write "</p>"
end if
intVendorID = rstResult("VendorID")
rstResult.MoveNext
loop
end if
set rstResult = nothing%>

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

Add Record On The Database

i use access database and made add record page and it is added on the database then i made another page to add on another table on the same database it is not working i donot know why,and the problem from me or from the server setting???

View Replies View Related

Want To Change Record

iam having problem ,relating to update a column in Access file in ASP
'Change' is column name , rs is recordset object ,and i want to update the values in 'Change' column by return values from a function .Iam using vb script in asp

rs ("Change").value = function()
this is generating error, and won't work

View Replies View Related

Empty Record

When there are no records for the certain row in my table I recieve this error:

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/admin/Fixture.asp, line 0

View Replies View Related

Record Set Paging

i am trying to expand the functionality of a page that is running on a
paging script.

i have tried several methods but cant get the results i want

is there an index to a record set that has sequential values (from first to
last) for the rows? if so how do i list it for each record?

View Replies View Related

No Record Notification

I have a page.asp?ID=xyz which redirects to releavant page and works if page exists but gives an error if not a valid page. How do I get it to redirect to an error message page being more user friendly?

View Replies View Related

Record Not Updating

I have a bit of ASP that gets data from the database and then displays it. This part works fine.

I then have anouther page to allow for changing this information, then i want to do two things, first show the updated info, and then update it in the database.

Neither of my updates will work and i can't figure out why.

I get this error: ADODB.Recordset error '800a0cb3'

Object or provider is not capable of performing requested operation.

I have checked the record it displays the info just fine, it will not update however. Here is my code for updating the record: Code:

View Replies View Related

Update Certain Record

i just wanna know how to be able to update certain fields without touching the others

for example if the form has 3 fields
description, name and age....

if i wanted to update the database from these fields, but only update the description while leaving the ohters as they are, which means blank fields in form...

now if i do that on my form, it will clear other 2 fields in the database and only update the description... how can i fix that so that when there's blank fields in form in won't clear the data in database ?

View Replies View Related

Record Selection

I have a form field called Streets that contains 'HIGH STREET,MAIN STREET'

I have a field in my access db called StreetName a single record would contain one street and I want to return all records that have a StreetName in the Streets field. How would I go about this?

View Replies View Related







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