Only Latest Record Got Customer Name.
i have table Comment and Customer. Customer is a registered customer. but, comment can be given by registered or non-registered customer. right now, i have 6 records which are 3 registered customer and 3 non-registered customer in Comment table.
for the non-registered customer, i put as a Guest for their name while registered customer, i have display his/her real name. my problem is, the latest record in Comment is a registered customer and her name is displayed in the html table but the rest registered customers, their names are not displayed. something wrong is there. for the non-registered customer, no problem at all. this is my script. at this page also has paging script. Code:
View Replies
ADVERTISEMENT
I want to display a little image next to the topic if the thread is recent and the user hasn't logged on in a while and then get rid of the image if he clicks on it.
What's the simplest way to do this?I obviously don't want to make a read/unread thing for every user.
View Replies
View Related
I would liek to select certain ESN number from my databas by the latest date. Even if the date on it is not current. Just all info by the latest dat.
Select * From <databasetables> ....
View Replies
View Related
I have a database with multiple records which are often updated. I am trying to display the latest entry in a certain way (with css div styles) and then list the rest of the entries another, less elaborate way.
Is there a good / preferred way to do this? Right now I have it so that it SELECTS TOP 1, displays that in a certain DIV, and then SELECTS * - however what is wrong with this is that it displays the first record twice.
View Replies
View Related
I wanna write asp code to pick up *.MAI from particular folder and read them. There is no problem with reading the file but how can I pick up the latest file from particular folder?
View Replies
View Related
I have been using ALS for a while, and I want to be able to create my own version, But the only issue I have is being able to track users realtime, ie get what page they are on, how long they have been online, and being able to contact them by throwing a pop-up.
ALS does it but i've tried scoping the coding, but can't find anything.
View Replies
View Related
I have a small team who are building e commerce sites for different clients .One of our client wants his customer orders to be faxed directly to him.
View Replies
View Related
I downloaded the latest version of the VB scripting engine for Windows 98 as I needed to have support for regular expressions. Everything was fine yesterday but when I switched my pc on this morning and tried to access micros personal web server/web manager via start/programs, the page where I click 'start' does not appear.
I can't get it to run. what has happened and how to rectify it. i am under huge pressure to get something done by the end of today and desperate to sort this out asap.
View Replies
View Related
I have a folder with eight or ten files that can be displayed in a browser. I need to display the file with the latest creation date. I imagine there is some kind of ASP function that could like at the filename's date and pick the file that meets the criteria. How can I do this?
View Replies
View Related
I am trying to come up with a select statement which would select info from the latest 5 dates. I know how to do the latest date using
SELECT * from table1 WHERE PDate = (Select Max(PDate)
Is there an easy way to write a select statement to give the latest 5 dates? My data is in a SQL Server database.
View Replies
View Related
I am trying to make a client login system with asp. the users register and their details get written to clients.txt. per client there are 9 lines in this txt file (name, address, etc)
username and pw are on lines 4 and 5. at login.asp i capture username and pw into strUsr and strPwd - that works fine. im unsure as to how i should not authenticate those variables against clients.txt.
- should i loop through all entries of clients.txt and compare strUsr and strPwd to line 4 and 5 of each entry?
- should i first create an array with the contents of the whole txt file and then see if strUsr and strPwd match any of the 4th and 5th lines?
View Replies
View Related
i have a page which lets u search for a tupple in the database.it allows the user to search by customername or jobno.so i have 2 text box to let the user enter.and each text box has a submit button which will link back to the same page and it will display all the search results.
i have error check script that dun allow the user to submit if nothing is entered.but now on my same display page... how mani i suppose to write the sql statment as i dun have idea to display the results from the customer search or job no search.
i mean i can write 2 recordset.but how do i make sure that it will display the 1 tat the user search.is there a if else way or sumthing??i mean if i search by job no.then when i request from the customer textbox field.wat is the value that is pass over?
View Replies
View Related
Just uploaded my database how to i create a simple page where i can enter customer details into my database. i would like fields like customer id, first name last name etc where the telephone number could be the primary key
View Replies
View Related
does anyone know of a site that takes you through a walkthrough on how to set up a client only area, but in javascript to use on an asp server?
View Replies
View Related
I have a client who wishes to make changes to their website live and without having to purchase any additonal software and do any training.
I have seen a few websites where they have an admin page where the client can login and make changes on the fly to the site through a browser. Does anyone out there know of any software that can do this or where i can find more info on this?
View Replies
View Related
I have an asp.net 2.0 web application that I have pre-compiled and deployed to a Windows 2003 server. When I try to access the web application I get thefollowing message in my browser:
'The file '/Customer/Login.aspx' has not been pre-compiled, and cannot be
requested'.
If I rename the folder containing the web app to something other than'Customer' then it works! I have tried deleting the folder and recreating it but I get the same problem. I have also copied the folder to another serverand it works without any problems.
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
