I have a table with 30 or so columns. I'm pulling the data and putting them into variables like so:
objRS.Open query, db
UserID = objRS("UserID")
That's obviously not including the db conn info or even the query itself. Rather than manually typing out each and every variable and pulling the data from the RS object, is there a function that will automatically store all the data from the RS into its respective variable? I'm basically just lazy and the carpal tunnel kicked in after 10 or so variables.
I've created a form where the user should be able to select an option, then a second list will be populated based on that selection. The next part is where I am running into trouble.
The user can also select a time window which can limit their search, if they so choose. Code:
OK I'm just starting out in asp, and the site will be mostly asp, which will be based around a shopping cart.
I would like to pull in a header and/or a footer into all of those pages.
Should I look into an ASP solution, or are there compatible ways such as CCS, or similar.
I only have experience with PHP server side includes, this is what I would like to emulate. I know there is normal SSI, but the pages need to be named .shtml, mine will be .aspx
I have a login script up and running and i have used a session variable to greet the user when they successfully login. what i am trying to do now is create a query to select other information from my database using the session variable, their username. i have been trying all sorts of different things and just cant get it to work.
I know that i have to do a select * where users = session variable(username)
but i dont get where in the code i put it... Here is the code of my protected page: Code:
I came across a topic regarding joining three tables, but couldn't apply it to what I am doing. I have three tables: Accounts, Reservations, Invoices. My goal is to put together a statment for each Account showing all outstanding Reservations and Invoices in chronological order.
Both Reservations and Invoices tables have their own date fields (Reservations - actual date of service, Invoices - date when invoice was created).
so basically Go through Accounts and then for each account that has either UNPAID Reservations or UNPAID Invoices populate a list of transactions where Reservations. ServiceDate and Invoices.CreatedDate should be listed in one column and sorted chronologically.
Here's my scenario: I send an email to my customers which contains an embedded URL with a recordnumber within it. What I want to do is create a variable for the recordnumber, write a select statement against my database using the variable as the argument for the WHERE clause, and display the results of the SELECT (its always a single value) within an HTML page.
Here are snippets of the code. The recordnumber is represented by strCallID and the resultset that I'm trying to display is strATG (shown near the bottom of the HTML) All the connection string stuff has already been taken care of, so that's not included in this code:
I am making an asp page that kind of gives a summary of a table I have on my SQL server. I have one field on the page of:
{rs_analyst_summary.TICKET_NUM}
Is there a way i can make another recordset that would use that field on the same page?
Basically what I have setup is a listing of all the tickets for one person. I need to have a score for each ticket as well. I have to start off on my first page by selecting my analyst. I want the page it links to have all of the analysts tickets and their score on each.
I have an access database from which I am pulling records. The main table contains all the info for a specific person and their business. I am retrieving the data and sorting based on last name, and I am also retrieving and sorting the data based on the specific region a person is in.
What I would like to do is also sort based on a sector that a person’s business is a part of. I would be able to retrieve all the records for each sector and sort them just as I did with region, but I don’t want to list ALL the sub-sectors. Code:
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<% Dim conn Dim rs Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") Set cmd = Server.CreateObject("ADODB.Recordset") conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa" conn.Open
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
How do i add data from table to cookie? I mean, I have an excel style table at website that is read from database via query, and what I want to do is add information, that is at the same line with the "apply" button, to a cookie for further use?
i used sql code above to display data in a table. basically, the flow is like this. when there is a new reservation, a staff will be assigned to handle that reservation from the beginning until the end. before this, i just display a staffCode that retrieved from Reservation table.
then, i made changes to display staffName and removed staffCode from the table (based on requirement). but, because previously, there are some reservations that have been assigned to staff, i do not have any problem to view all data in the table.
but, when i click other reservations that have not assigned to any staff, an error page came out. the default value for staffCode in the Reservation table is null. because this null value, i've got an error page. is there any steps i can use to solve it?
Right i got the login page working, on my main page i have a big table in the middle with a few small tables either side of it, one of the smaller tables has a form where you can search a database, is it possible to have the results of the search appear in the main table? and is it difficult?
Is it better to use the Recordset methods or make an SQL query string and use conn.Execute() if I want to add to a table? I figure the first might be safer, but it seems weird to someone who learnt on PHP... I'm using SQL Server if that matters.
I have coded a form which enters data into a access table however I want the same recordset when clicked to go to another table in the same database then when clicked again to go to another table within that database...is this possible?
If i created three different type of table. Inside these tables, they might have the same key field's name. Example:
Table A - ExecNo, Month, Year, CustCode Table B - ExecNo, Month Year, DestCode
as u can see that these two tables have almost the same key field but they r actually keeping different data. how can i list these different data out in an asp page? it is because i am having the problem whereby.
where the table want to display data from table B, it actually misplace by table A . how can i write the sql function to differentiate both of them.
I have a table that's holding 'open data' until it needs to be moved to another table where it is then 'closed'. I think I have my SQL statement correct to do this, but I keep getting the error below.
Quote: Originally Posted by Error Message [Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
I have verified that I have the same number of fields in each table, but I think the problem is both tables have an Autonumber field and obviously you cannot move one autonumber field overtop another one. What is the easist way to exclude my autonumber field from being inserted into my other table without having to call every single field by name in the SQL statement? Code:
1. populating letters in the bottommost row randomly 2. On selecting any letter in the bottommost row, and pressing any column in the top rows (Row1 Col1), the letter should be displayed in the desired location (Row 1 Col1)
Is it posible in ASP to hide a table that brings no data when you query a data base and if you have two tables that brings different information?. If it's posible, can you guys help me with this one please?. The table that I would like to hide is the one that brings no data.
<table> <tr> <td>1 to 10 records</td><td>11 to 20 records</td><td>21 to 30 records</td> </tr> <tr> <td>31 to 40 records</td><td>41 to 50 records</td><td>51 to 60 records</td> </tr>
</table>
I tried with rowcount it is displaying in a row ancontinully with if conditions also. how to do this or any example script.
I'm involved in this localization project, and part of the process is taking the english content out of the pages and storing them in the db as key/value pairs (which we call tokens).
Would be any performance problem if all of the tokens were stored in one table, for each language. Say there’s 1000 Tokens, and there’s 50 languages supported, then that would be 50000 entries. It's hard to guess how long each string will be... Ok, that’s not very big, but what if we were to load that up in the application scope, so it would be easily accessible (maybe in a dictionary object for each locale). Do you forsee any problems in that? Or does ASP offer some other caching mechanism for this?
I need to solve this as part of a class project. It is designed to simply read a SQL table and display the data in the browser. But it will only show one record based on ID at a time. So if I have multiple records with the same ID such as page.asp?ID=9734, it would show all records using that ID in the browser. Code:
