I have a page that is supposed to display a certain piece of art, along with the title, description, and other thing, which are stored with an access database table.
Theres a page that you are sent to:
http://skeddles.com/pixel.asp?f=1
I want the page to look through the table in the ID column, find the number obtained from the url, and let me get the other information in that row.



Also, how do I upload a file and get the filename?

Also, how do I upload a file and get the filename?

How to do both? or just get the filename from an uploader you are already using?

I want the page to look through the table in the ID column, find the number obtained from the url, and let me get the other information in that row.

SELECT fieldlist FROM table WHERE table.id = [idVariable] ;

Um, I guess both.

and when i tried to use that, i got "Syntax error in FROM clause."
Theres probably a ton of things wrong with my code:
<%
dim i
i = request.querystring("f")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("d/s.mdb")
Conn.Open

varf=Request.QueryString("f")

Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "SELECT fieldlist FROM table WHERE table.id = [varf] ;", Conn, 1,3


%>

"fieldlist" is a placeholder for a list of columns from YOUR table.

eg

SELECT title,description,author FROM

"table" should be replaced with YOUR table name

"table.id" should be replaced with YOUR table name and the column for the ID No

remove the [ ] from around the variable name and concatenate the variable value onto the string

eg

... mytable.id = " & varf & ";", conn, 1, 3


ENSURE THAT YOU "sanitise" the value coming from the querystring to minimise SQL injection attack risk, AND variables recovered from a form or querystring will be string. Your ID value is more likely to be an integer, so will need "casting" to an integer value with

varf=cint(Request.QueryString("f"))

Um, I guess both.

Ok

take a look at
http://www.webmaster-talk.com/asp-fo...extension.html
&
http://www.webmaster-talk.com/asp-fo...file-size.html

for a somewhat modified asp file upload script.

Adding a name property to the class shouldn't be a problem.

Originally Posted by chrishirst

Ok

take a look at
http://www.webmaster-talk.com/asp-fo...extension.html
&
http://www.webmaster-talk.com/asp-fo...file-size.html

for a somewhat modified asp file upload script.

Adding a name property to the class shouldn't be a problem.

I changed my mind, can you help with my previous script? Here it is:

<%
Dim oFileUp             

Set oFileUp = Server.CreateObject("SoftArtisans.FileUp")

oFileUp.Path = Server.MapPath("s")

If Not oFileUp.Form("myFile").IsEmpty Then

oFileUp.Form("myFile").Save
num=oFileUp.Form("myFile")

Response.Write ("File:")

path=oFileUp.Form("myFile").servername
filnum=len(myFile)
num=filnum

Response.Write(oFileUp.Form("myFile").ServerName)
response.write("<br>")
response.write (right(filnum,num))
response.write (num)

Else
Response.Write("Error: There was no file submitted for upload.")
End If


Set oFileUp = Nothing
%>

It gives me the path to the file on the server, but thats not what I wanted.

In that case. You could always look at the SoftArtisans FileUp documentation.

http://support.softartisans.com/docs...erfilename.htm
or
http://support.softartisans.com/docs...rtfilename.htm