Integrating Asp Into A Table To Auto Generate Rows From A Select Statement

Im running a select statement to a database and wish to display the relevant records into a table. For some reason, its not liking this - can someone see why, and or tell me an easier way to produce an 'automatically generating' table of results.

<% @language="vbscript" %>
<% Option Explicit %>
<% Response.Buffer=True %>
<html>
<head>
<title>Search Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<!-- #include file="dbConn.asp" -->
<!-- #include file="adovbs.inc"-->
<h1>Your search results returned the following popup messages:</h1>
<% Dim msgtype, title, message, url
msgtype=request.form("type")
title=request.form("title")
message=request.form("msg")
url=request.form("URL")

Dim adoDB, adors, strSQL
set adoDB = Server.CreateObject("ADODB.Connection")
adoDB.Open strConnection
set adoRS = Server.CreateObject("ADODB.RecordSet")
strSQL="SELECT PID,P_TITLE,P_MSG,P_URL,P_TYPE FROM POPUP WHERE ("
If msgtype <> "" then
strSQL=strSQL & "P_TYPE='" & msgtype & "' "
If title <> "" then
strSQL=strSQL & "OR P_TITLE LIKE '%" & title & "%' "
If message <> "" then
strSQL=strSQL & "OR P_MSG LIKE '%" & message & "%' "
If url <> "" then
strSQL=strSQL & "OR P_URL LIKE '%" & url & "%' "
End if
strSQL=strSQL & ")"


'DEBUG ONLY!!
'response.write strSQL
'response.end

adoRS.Open strSQL, adoDB
' Loop through the recordset to display the records
Do While Not adoRS.EOF
& " <tr> " &
& " <td> " & Response.Write adoRS.Fields("PID").Value & " </td> "
& " <td> " & Response.Write adoRS.Fields("P_TYPE").Value & " </td>"
& " <td> " & Response.Write adoRS.Fields("P_TITLE").Value & "</td>"
& " <td> " & Response.Write adoRS.Fields("P_MSG").Value & "</td>"
& " <td> " & Response.Write adoRS.Fields("P_URL").Value & "</td></tr>"
adoRS.MoveNext
Loop
& " </table> " &


' Tidy up afterwards
adoRS.Close
Set adoRS = Nothing
adoDB.Close
Set adoDB = Nothing

%>

</body>
</html>

View Replies


ADVERTISEMENT

Auto Generate By Select Box

I have a select box with site ids that are retreved form a database. I need to select one and have the company code and cost center code auto potulat a tbl field. I though about this in js however the conflic with server side and client side got in my way
here is what I have : Code:

View Replies View Related

Auto Generate Number

I want a sample code for developing an " auto genearte number " and want to store in database.

View Replies View Related

Auto Generate A Primary Key

I wan to ask isit can generate a primary key before to insert a new record from
asp to database (ms. access 2003). wat coding should i write for generate a primary key
that unique? i cant find a solution to do that. my primary key will be sequences like :M0001, M0002...... follow

isit possible i genrate a primary at ASP pages before store/insert into the database?

View Replies View Related

How Many Rows Are There In Table

adoRS.Open "select * from table_name"

numField = adoRS.Fields.Count
response.write("Number of Filed of table_name = "&numFiled)

how will i know how many rows are there in table_name? is there a

numRows = adoRS.Rows.Count

any help with this?

View Replies View Related

Generate A Table With ASP

I need to create a table with 4 cols and X rows based on the number records
in my database. I dont know how this can be done, mabye with an array?

If I got for example 6 records in my database, a table with 4 cols and 2
rows should be generated, the last row will only have 2 cols with
information... Code:

View Replies View Related

Insert Statement Adding 2 Rows

i tried to insert data's to a table and its working ..but the only problem is when i click the button Submit(to add data)its adding 2 rows of data... 1 is the data's which i entered n the other 1 is a blank row of data...so when i log out n run the form again..error occured.. saying that confilcts in a primary key.. coz there is a blank rows in the table... Code:

View Replies View Related

Alternating Table Rows...

How do I do alternating table rows? I'm just using the:

[vbs]

rs.movenext
loop
[/vbs]

method...so, it's in a table...I looked on ASP101, but that's the wrong kind've database setup I have...

How do I do it? It should look like:

[vbs]
<tr>
<td class="Alt1"></td>
<td class="Alt1"></td>
</tr>
<tr>
<td class="Alt3"></td>
<td class="Alt3"></td>
</tr>
[/vbs]

View Replies View Related

Dynamic Table Rows

I have an ASP VBScript page with a dynamic table.
Each row contains a dynamic price, a qty field, and a total. The total on each row changes (onChange() ) when a qty is entered (this works fine).
I now need to total up the 'total' fields and put a 'GrandTotal' into a variable for later

View Replies View Related

Table Rows And Recordsets

I'm wondering if it's possible to write recordsets into HTML table cells, say, 3 columns wide using a loop? I've tried it but obviously I need to get 3 records out at a time so I can't detect the end of file. Any ideas?

View Replies View Related

Alternating Table Rows

a way that i can alternate the colours of my table rows?I know that you can do it in .net if there is a fairly simple way to do it in standard asp.

View Replies View Related

If Statement To Arrange Big List Into Rows And Cells

I need to come up with an if statement that will basically take a large list of records and place each one into its own table cell, and when the cells reach a max of 5 in a row, start a new row and repeat. How can I go about this?

View Replies View Related

How Do You Add Several Rows To The Same Table With An Update Button!!!

I'm trying to update several rows to the same table of a datbase using ASP & an access database.

But I can't seem to get it working. I can get it working for one row but more than that won't work. The amount of rows that need to updated is never the same.

View Replies View Related

Can ASP Table Display 200 Columns, 500,000 Rows?

I'm sure it sounds kinda nutty to display 200 columns and
500,000 rows of data. But I have been pulling data from a
Lotus Notes database into Sql Server for a while now, but
Lotus Notes is starting to crack, columns getting
corrupted. Can't handle the volume of data and number of
columns. Sql Server has no problem. But displaying the
data is the big deal. The end users want to be able to
scroll acros a page to the colum of their choice, or be
able to scroll up or down.


I was thinking of breaking up
the table into section, but this would reqire additional
clicking to get to the next section of the table. Would
it be feasable to have a 200 column table in asp? or
should I stick with the section idea? I have to tell my
dept something. They started out with Lotus Notes but
couldn't query the data. I have been suggesting to
migrate the project entirely to Sql Server/IIS. Notes can
at least display all the columns.

View Replies View Related

Split Color On Rows In Table

I am creating a table with two rows(one of which is the header), and 8 column headings. In the 2nd row, i am trying to apply 3 different colours that span various length across the row. I want the row to loop adding one colour directly to the end of another, but adding this to the correct length of colspan for each colour.

The code below is what i have done so far, but i only get a blue colour in the 3rds cell.
Eventually i would like to have a variable length of row, as i do not yet know how many rows i need (this will be dependant on something else). But i would like the colour method to be applied to each row.

Also i need to be able to make colspan variable so after each loop, it will be updated by the new column amount ....

View Replies View Related

Generate List Of Table Names

Anyone have any advice on getting a recordset of all tablenames in a database? I have an access database that I am constantly adding tables to.

I want to have code that will lookup all tables and populate a selectbox with the tablenames so that I can click to look at each table individually.

View Replies View Related

Generate An HTML Table From A Database

I am using ASP to generate an HTML table from a database. I use FSO to output a file with an XLS extension then open it. I can set the column width and row height; I can set the font family, size, and weight. I know I can include formulas in a "cell".

What else can I do when I generate the table that will take effect when the file is opened in Excel? I'd like to do things like autofit and sorting. The client does allow Office Automation on the server so I can't write to Excel directly.

View Replies View Related

Adding Rows To Database Table Thro ASP

I want to add a row to library table. Table has total 7 fields. But I
want to create the new row with 5 field data. When I run the following query
in MS Access

strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES
('B-096','Hihihihihi','hello','Book','07/18/04')"

It successfully adds the row. But same thing I am trying with the following
ASP code. It gives error, saying syntax error in INSERT into statement. Code:

View Replies View Related

How To Trigger OnChange Or OnClick Events For Multiple Rows In Table??

I can trigger these events successfully if table only has one row:

Sub InputField_OnChange()
......
End Sub

But, these events cannot be fired if table has more than one row, why?

View Replies View Related

Auto-escape INSERT Statement

I have a 'memo' form field being entered into an access database.If people put in characters other then text (Quotes, operators, etc) then I get an insert error:
----
User Input: oh let's see - a va

Error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''oh let's see - a va', 'No additional comments submitted')'.
----

Is there a way to get this into the database? In php, I would simply use the function 'addslashes()' (escaping the string) - is there a similar function in ASP or am I doing something else wrong?

View Replies View Related

Auto Increment Table

I'm trying to implement a feature where when user click on a button, a table will be displayed in the page and when second time the user clikc on the same button, the other table will be displayed, and so on. can anyone give me an idea on how to implement this?

View Replies View Related

ASP Auto Updating An HTML Table

I need to create a webpage with an HTML table that keeps track of certain data. I have created the table and hardcoded all the nonchanging cells.

The problem is the data I need to update the table with is FTP'd to a webshare in a .txt format. I need to take this file, parse it and update the table every morning at 745.

I have found ways to do it if the webpage receives a hit, but I still need it to do it on weekends and holidays when we are not in the office, because this file will be overwritten with the new data file the next day.

View Replies View Related

Auto Update Table Field

I am developing small asp application.There is a database called db.mdb and there are three tables(tblUser,tbsImport,tblcitylist) In tblcitylist there are two fiedls

1.Town
2.LReg

According to the relevent town there is a LReg (Lreg is a name already assign to the town)
this part is ok.

In my tblUser there is a field called Town and LReg (Same as above table)
But here LReg is empty.I mean there is a default value called "N/A"

I need to create a asp page for following purpose

* i need to read tblcitylist table and according to that I need to fill the LReg fields of TblUser Code:

View Replies View Related

Select Statement

how do you select all the fields in a table that do not contain any data?? I have tried the below and it wont work??

View Replies View Related

Select Statement

I am trying to display a feild from the table. But there is a Type Mismatch error that I am getting. Can anyone please take a look at my code to see what could be wrong.

The error that i am getting is:
Microsoft VBScript runtime error '800a000d'

Type mismatch

/jobapplicationnew.asp, line 1285
Line 1285 is highlighted.

Code:

View Replies View Related

Select Statement

following is my select statment code, works partially fine but the city search is not working.. i.e it gives me list of all hotels that start with the given words whereas it should give me hotels in the given city only. pls help me out. thanks

sSQL = "SELECT * " _
& "FROM [hotel] " _
& "WHERE hotel_name LIKE '%" & Replace(hotel_name, "'", "''") & "%' " _
& "OR hotel_name_e LIKE '%" & Replace(hotel_name, "'", "''") & "%' " _
& "and city = '"&city&"';"

View Replies View Related

Select Statement

the select statement as per the following relationships:

drop1id has 1 to 9 records.
drop2id has 1 to 65 records - FK drop1id will be 1 to 9
drop3id has 1 to 356 records - FK drop2id will be 1 to 65
drop4id has 1 to 356 records - FK drop3id will be 1 to 356.

I am not sure how to retreive the records based on their relationships.

View Replies View Related

Select Statement

does anyone know if its possible to look through a field in a database and see if it contains certain keywords?

i am using a database with a field called MainIssue and i want to see if it contains keywords and if it does, to display the contents. is there a command which would do the same thing as:

select * from maintable where field contains "keywords"

View Replies View Related

Select Statement

I am having problems with a select statement in asp with an access database.
I pull First and Last information from my form
First = Comes from form
Last = Comes from form
I have validated that the form information is being pulled this is where my problem lies.
Code:
SQL = "Select Listing where (FirstName =" & First & ") AND (LastName =" & Last & ")"
For some reason I can not pull the information for the database using this. If I take the AND (LastName =" & Last & ") out I can pull some of the information, but I am looking for a specific last name, first name entry.

View Replies View Related

Select Statement

i have the following tables in my Access database

info1, info2, info3...

all tables have the same columns with the same type of data.

code, description, activated etc.

now i ask the user to enter a code, and then it searches through all the tables for that code. the reason i broke it into smaller tables is there is 10s of thousands of records.
it should find the record that match with the entered code and then if the user wants to, he can edit the data, the date is then automatically saved into the record as well.

View Replies View Related

Select Like Statement

Some of my pages include paging where the variable starts with a certain letter. This worked fine in access but when I try to run it with mysql it says...

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT username, status FROM users WHERE username Like 'A%' OR

View Replies View Related

Select Statement

This is really simple but for some reason no recordset is returning. I can't get cat_1 to write. I have run the query against the database in Query Analyser and it runs fine.

Code:
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = "Driver={SQL Server};Server=nzlakldwhse;Database=Complaints;Uid=elkuser;Pwd=elk;"
objConn.Open

Dim objRS
Dim cat_id, cat_1, cat_2
set objRS = objConn.Execute("select cat_id, cat_1 from complaints.dbo.category a where a.cat_id = '"& request.form("cat_id") &"'")

response.Write(cat_1)
response.End

View Replies View Related

Select Statement

Code:

[advsearch = "Select * from img_inv where item_num like '%" & item_num &"%' or category = '" & category &"' order by item_num"



I want it to be able to search the db by like item number or exactly equal it a given category list.

View Replies View Related







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