Choose A Record
i have a database with one table... there are about 10-20 records in the table. i would need to create a page that displays a few descriptive fields of the records. just something like this.
ID NAME PRICE
1 type1 345
2 type2 567
3 type4 1000
just a simple list like this in a table, also each record would need to act as its own hyperlink, so when clicked on. using the primary key i presume, it loads another page specifically for that record. almost like a catalogue..if someone could please direct me to a few tutorials or online examples of this kind of procedure.
View Replies
ADVERTISEMENT
ill have a database with 1 table and 3 fields:
ID FIRSTNAME LASTNAME
(the ID field will be the auto incrementing index)
there might be 10 records in the DB, there might be 10,000. i need to open the DB and randomly select a record (and then display the name, which i dont have a problem with)
how can i randomly select a record? im guessing id have to open a recordset and check the count to get the number of records, so lets say there were 100 records. i imagine i would have to generate a random number between 1 and 100....
View Replies
View Related
What Content Mgmt Systems do forum members and ASP pros use?
I'm looking for something fairly sophisticated (WYSIWYG editor, user permissions, versioning, audit trail, etc) that doesn't cost an arm and a leg. It should be pure ASP, and (naturally) available with full source code.
View Replies
View Related
I want to allow a user to select a windows folder for reading. I have tried
to work it out without success. Can anyone help me out or point me in the
right direction. I am an experienced VB6 programmer but this is my first
ASP.Net project.
View Replies
View Related
Is it possible to set the sessionID = value?
I am storing a shopping cart in a in a temporary table and with the sessionID identifying which items belong to the different users. Ideally I want to set it to a random GUID or number so it will make it very hard to guess the next session ID and gain access to another cart if they knew what they were doing.
Any ideas on how to set the sessionID value? Do I need to go that mush in to detail?
View Replies
View Related
i need to choose a data, randomly, in a database based n category (cat1, cat2, cat3, cat4, cat5, cat6). i only need to show 1 data of each category in the html page. kindly inform where to find a sample tuts for this.
View Replies
View Related
I've just had a problem with an ASP page not connecting to one of our Oracle databases. It turns out that the web server has Oracle 8.1 and Oracle 9.2 installed and that my
ASP page was trying to connect with Oracle 8.2. The TNSNAMES.ORA file for this version of Oracle is not maintained and did not have the correct entry I need.
Is it possible to force my ASP pages to use Oracle 9.2 until the migration is complete and Oracle 8.1 is removed?
My connection string looks like this:
Session("PROVIDER") = "Provider=OraOLEDB.Oracle;Data
Source=ht;User Id=" + Request.form("username")
+ ";Password=" + Request.form("password")
View Replies
View Related
I like to validate 2 textboxes. Users ken choose to enter either one. Therefore if nothing is entered for both, im suppose to prompt him to enter at least one. If he enters value into both txt boxes, I'll prompt him again. Dunno to post this here or @ javascript forum.
View Replies
View Related
i have a folder contain many images in a server, i got to do a web application allow user to choose image the from the folder in the server to be their signature, may i know how to get into the image in the folder on the server?because from what i know i can do a textfield to browse to the file in my local machine, but how do i browse throught the fiel in the image folder that i mention?
View Replies
View Related
I have a SQL 2000 stored procedure with several recordsets. Is there a way to query a specific recordset in a stored procedure, or will I have to loop through each recordset?
View Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
