Creating A Table In ASP

I would like to create a table 500px wide and it should have 4 columns and 8 rows. I would like one of my images to take up each of the cells (I have 32 images). To do this I need to insert this code into each of the cells-

"<a href=""products.asp?Country=" & rsproducts("country") & """><img src=" & rsproducts("Thumb") & ">"

What is the best way of achieving this?

View Replies


ADVERTISEMENT

Creating XL Sheet From Query Table In ASP

Using regular VB ASP (not .net) and calling an Access database using ODBC, I've generated a recordset based a query... (no big whoop, obviously)

Now I want to be able to open a new XL spreadsheet (client side - we're assuming user has XL) and export that table to it. I've seen some posts about DoCmd.TransferSpreadsheet, and CreateObject("excel.application")... I've never actually used them before, so I don't know where to start.

I'd like to have a link on the page with the table to "export to XL"... and then have it open XL (client side) with that table in a spreadsheet.

View Replies View Related

Creating A Best Sellers List From My Orders Table

I'm creating an online shop which has an area showing the top ten best selling products. I'd like to generate the list of the best selling products from my OrdersDetail table (which is table showing listing purchases made on the site), ordered by the most popular at the top and the least popular at the bottom.

I thought if I could use the SQL DISTINCT command this would create a list of products without duplicates, then if I could COUNT them I'd generate a list of the most popular products in the OrdersDetails table. This nearly works but the list won't ORDER BY the COUNT column (I get an error). This is my code so far:

SELECT DISTINCT ProductDescription, COUNT(ProductDescription) AS bestSellers
FROM OrdersDetail
GROUP BY ProductDescription

View Replies View Related

How To Transfer Records From One Table Of A Database To Another Table In Another Data

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

startdate=request("tarikh1")
enddate=request("tarikh2")

MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....

View Replies View Related

How To Open A Recordset For A Table Has Space In The Table NAME?

I am trying to display the content of a Table called

'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:

Set tableSet = Server.CreateObject("ADODB.Recordset")

tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable

where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.

I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause

which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?

View Replies View Related

Table Inside A Table Update To DB

I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??

Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:

View Replies View Related

Copying From Table 1 Inserting In Table 2

I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:

View Replies View Related

Bookmarking A Position In A Table <table>

Have an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.

Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.

View Replies View Related

How To Get Data From A Table Into A Table Form?

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:

View Replies View Related

Best Method Of Updating Table From 2nd Table

I have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.

Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.

Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.

View Replies View Related

Record Set For Id From Table 1 To Table 2

Hello I have a page for registering users.

I am reciveing this error:

The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.

there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.

I have a form designed to capeture the need information.

in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.

then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:

View Replies View Related

How To Make Column Of Table 1 = To Column Of Table 2?

I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:

View Replies View Related

Creating A New Asp.net

Environment:
Development PC: W2K Professional
WebServer: W2K Server, IIS 5.0
Peer-to-Peer network

I'd like to create a new asp.net project on a remote server (not on the
local (development) machine. I have looked for info on how to do this, but
all I can find are instructions on how to create on localhost, then deploy
later to remote machine.

View Replies View Related

Creating An ASP

what's involved in creating an ASP? I need to create a web page where users can check their past history of the account.

View Replies View Related

Creating XML In ASP

So i currently have an asp page that creates an xml document with information from a database. However I need to link to my schema when creating the Root element here,

Set objRoot = objDom.createElement("projects")

this is the link that would go into projects:

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="semesters.xsd"

View Replies View Related

Creating A String

Im trying to create a string from checkboxes that have been checked, but for some reason its not working

strNumbers = ""
for each key in request.form("chkFacility")
strNumbers = strNumbers + "" & key & ","
intCount = intcount + 1
next

So I want to end up with a string like this '3,12,7.' Instead Im just getting a single number. Am I doing this the right way. Any help wud be just fantastic!!

View Replies View Related

Re Creating A .csv File

I know how to use ASP to create and write into a .CSV file on the server, but I have a small problem. Every time I write to the file I am adding new lines each time. I don't know how to wipe the previous contents out, and I thought this is probably a no-brainer for you guys ...

So, I'm looking either to delete the file at the start of the process and start from scratch or

* open the file
* wipe all contents from file
* write to the newly cleaned file

View Replies View Related

Creating A ZIP File

How can i create a ZIP file from a folder (full of files) of the server.?

View Replies View Related

Creating A New Cookie

I have an asp page where i created cookies-for admin and for user. The aspx page reads these cookies. Everything seems to work fine but now i have to create a new cookie if cookie has expired or if cookie is null. Also, i am having problems with the expire because if the username belongs to the admin for example and then i want to change
the username that belongs to a normal user the cookie recognises the first (admin) cookie. How do i solve this? .....

View Replies View Related

Creating Fields

I want to create an order form for prints online... I will have up to 200 prints to be selected. What I am thinking is that I will have an HTML Form that has all the 200 thumbnails with a check box next to them. They select the ones they want and push next. Then I would like it to create a set of options for each one they selected.

That basically says the image name then has a check box for 5x7, 8x10 and a text box for the amount for each... I do I create the page what creates these selections and how to I incorporate that into a mail form going to the next page?... it seems like a simple enough idea. Am wondering how the reality of it will be.

View Replies View Related

Creating An Odd Array

I am trying to pass a form value and pull some values from an array. I am getting no errors but no values on this code. Any ideas? Code:

View Replies View Related

Creating A Menu Using ASP

I am using asp and access database. I need to create a menu according each member access. In other words, if member login I need to display the menu according to the services the member selected during registration. Each service contains diff type of products.

Service1
-produc1
-product2
Service2
-produc1
-product2
-product3
..more
Service3
-produc1
-product2
..more

What is the best way to this...

View Replies View Related

Creating Rss Newsfeed

i have website which provide daily news. we store the news into sql database. i want to create a rssnewsfeed which i can provide to other websitemasters. can anyone tell me the asp code or other where i can create rssnewsfeed from my sql data.

View Replies View Related

Creating A Task

I have a problem. I have a database with 1000 e-mails that i use in my
mailinglist. And when i send them mails it takes kinda long since i attach a
..pdf file each time. so i was wondering if there is a way in asp to create a
task on the webserver using asp to trigger a script that sends the mails.
sure i could use server.scripttimeout but the thing is that i dont want to
wait 30 seconds for the page to finish loading. and if there will be 3000 in
near future i'll have to wait for a very loooooong time.

anyone know how to create a task using asp dynamically?

View Replies View Related

Creating Thumbnails

I'm doing a gallery and I need to make some thumbnails of the images, but yeah...I don't know how, especially since I can't access the server to install stuff. And to be honest I wouldn't know how to install them in the first place (linux server)

Now...the best solution I've come up with so far is to send a string to another webserver that runs on a decent platform and use asp.not to make the thumbnail and then link it from there...would be a pain in the butt though, so if anyone has some good advice then I'm all ears (even if the advice is to give up, tbh)

View Replies View Related

Creating PDF Reports

I'm pretty new to the whole concept of Server Side programming and am currently developing some important elements for a site I have made with Classic ASP programming. One of the things my employer wants me to develop is a Server Side script that will allow a report in PDF format to be generated online to customers who make use of the tools.

View Replies View Related

Creating Hyperlinks?

I need to format each row being returned in a recordset as
a hyperlink. One of the fields being returned is the
subject of a message that my hyperlink will show. When
the hyperlink is clicked then the ASP page loads further
message details of that link. Does anyone know how to do
this?

View Replies View Related

Creating A Graph With ASP

I have the following graph (see atttached file) and was wondering if it would be possible to create this graph by using ASP and how easy it would be. If it is possible could someone give me a few links to sites where I could get some code to start me off.

View Replies View Related

Creating Folder Using ASP

Is it possible to create a folder using a virtual path? This is for a site on a shared hosting server.

View Replies View Related

A Few Questions About Creating Using Asp

First, how can I get asp to create a table in en existing DB that is an atuonumber. Meaning.. If say table 56 exists alrady, I want it to create 58 as the name. Along with this, I need to copy the fields from table temp, into the above DB. Can this be done?

View Replies View Related

Error Creating COM

I get a "-2147467259" error (unspecified error) when I try to instantiate an
object on my web page. the object is in registered in the Component
Services and when I test the component manually by a VB app, it works fine.
My web site virtual directory security settings allows me to execute scripts
(if that helps).

View Replies View Related

Creating Rtfs

I am currently pulling records from my database and exporting them to rtf.
My problem however lies in formatting the data in the rtf. More specifically with putting the data into a table.
Does anyone know how to control the width of a table when generating a rtf?

View Replies View Related

Creating Sub-recordsets

How do I create a recordset from another?

e.g.
sSQL1="SELECT * FROM ThisTable"
rs1.open sSQL1,conn

sSQL2="Select * from (rs1?) WHERE name='fred' "
rs2.open sSQL2,conn

View Replies View Related







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