getting the function to work

biry · Jan 31, 2005

hi, i'm trying to use the tutorial here:

http://www.4guysfromrolla.com/webtech/031000-1.shtml

but i can't seem to return anything, infact no errors just hangs.

i'm tring to get column values, starting with "Form" from

http://www.sec.gov/cgi-bin/browse-e...SIC=&State=&CIK=&owner=include&accno=&start=0

i'm trying to get the scripts to work by calling the function like so:

Call GetCell("2","

http://www.sec.gov/cgi-bin/browse-e...C=&State=&CIK=&owner=include&accno=&start=0")

how does this work? Thanks for the pointers!

ChrisHirst · Jan 31, 2005

Hopefully you do have ASPTear installed on your server.

and the function call should be

variable = GetCell(cellnum,url)

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

biry · Feb 1, 2005

as a test, this isn't working:

variable = GetCell(2,

http://www.yahoo.com)

error:
Microsoft VBScript runtime error '800a01a8'

Object required: 'www'

/todaysq3.asp, line 98

if i use without www. i still get object expected and if i use the http:// i get error of:
Microsoft VBScript compilation error '800a03ee'

Expected ')'

/todaysq3.asp, line 98

variable = GetCell(2,

http://www.yahoo.com)

I even tried to put quotes around the url and also tried with quotes around the cell number, still no luck

any thoughts on this? thanks

trollacious · Feb 1, 2005

Do you have quotation marks around the URL? Your examples here didn't

variable = GetCell(2, "

http://www.yahoo.com")

biry · Feb 1, 2005

yes i've tried that with no luck - i get a blank screen. I thought maybe i'm calling a null cell number to i tried running the NumberCells function:

variable2 = NumberCells("

http://www.yahoo.com")

in which i also get a blank screen

when i view source of the blank screen i get:

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>

not sure if the server is creating these tags, cause i don't know they are comming from...

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

getting the function to work

biry

Technical User

ChrisHirst

IS-IT--Management

biry

Technical User

trollacious

Programmer

biry

Technical User

Similar threads

Part and Inventory Search

Sponsor