|
 |
asp_web_howto thread: Text Fields
Message #1 by "O'Hara, Elliott M" <EMOHARA@k...> on Tue, 16 Oct 2001 07:01:00 -0400
|
|
I've got a with quite a few fields. Has int,bits,dates these work fine- but
It has like 6 text fields- none of them show, at least not in my asp pages.
It works fine in SQL Query Analyzer, but nothing shows up from my pages...
Any ideas why?
Oh, its on my development server, so I won't blame it on SP2 :)
(inside joke)
Message #2 by David Bosomworth <David@s...> on Tue, 16 Oct 2001 12:52:38 +0100
|
|
Hi,
I think I had the same problem
This worked for me...
In your sql select statement, be sure to put the text fields at the end of
the select statement (and in the order you intend to access them)
For example
sql = "Select bitdata, intdata, text1data, text2data From......."
Also, once you have referenced text1Data in your asp page you won't be able
to reference it again, if you need it twice then assign it to a variable.
hope this helps
Dave
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: 16 October 2001 12:01
To: ASP Web HowTo
Subject: [asp_web_howto] Text Fields
I've got a with quite a few fields. Has int,bits,dates these work fine- but
It has like 6 text fields- none of them show, at least not in my asp pages.
It works fine in SQL Query Analyzer, but nothing shows up from my pages...
Any ideas why?
Oh, its on my development server, so I won't blame it on SP2 :)
(inside joke)
Message #3 by "O'Hara, Elliott M" <EMOHARA@k...> on Tue, 16 Oct 2001 08:24:01 -0400
|
|
I'm doing a SELECT *
Should I explicitly call the fields (I'm pulling them in the order they come
up)
-----Original Message-----
From: David Bosomworth [mailto:David@s...]
Sent: Tuesday, October 16, 2001 7:53 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Hi,
I think I had the same problem
This worked for me...
In your sql select statement, be sure to put the text fields at the end of
the select statement (and in the order you intend to access them)
For example
sql = "Select bitdata, intdata, text1data, text2data From......."
Also, once you have referenced text1Data in your asp page you won't be able
to reference it again, if you need it twice then assign it to a variable.
hope this helps
Dave
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: 16 October 2001 12:01
To: ASP Web HowTo
Subject: [asp_web_howto] Text Fields
I've got a with quite a few fields. Has int,bits,dates these work fine- but
It has like 6 text fields- none of them show, at least not in my asp pages.
It works fine in SQL Query Analyzer, but nothing shows up from my pages...
Any ideas why?
Oh, its on my development server, so I won't blame it on SP2 :)
(inside joke)
emohara@k...
$subst('Email.Unsub')
Message #4 by David Bosomworth <David@s...> on Tue, 16 Oct 2001 13:46:25 +0100
|
|
you'll need to specify each of the column names separately (this is also
faster than select * )
when you do this make sure that fields with "text" datatype are at the end
of your select statement
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: 16 October 2001 13:24
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
I'm doing a SELECT *
Should I explicitly call the fields (I'm pulling them in the order they come
up)
-----Original Message-----
From: David Bosomworth [mailto:David@s...]
Sent: Tuesday, October 16, 2001 7:53 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Hi,
I think I had the same problem
This worked for me...
In your sql select statement, be sure to put the text fields at the end of
the select statement (and in the order you intend to access them)
For example
sql = "Select bitdata, intdata, text1data, text2data From......."
Also, once you have referenced text1Data in your asp page you won't be able
to reference it again, if you need it twice then assign it to a variable.
hope this helps
Dave
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: 16 October 2001 12:01
To: ASP Web HowTo
Subject: [asp_web_howto] Text Fields
I've got a with quite a few fields. Has int,bits,dates these work fine- but
It has like 6 text fields- none of them show, at least not in my asp pages.
It works fine in SQL Query Analyzer, but nothing shows up from my pages...
Any ideas why?
Oh, its on my development server, so I won't blame it on SP2 :)
(inside joke)
Message #5 by "Daniel O'Dorisio" <daniel@o...> on Tue, 16 Oct 2001 08:43:48 -0400
|
|
Nah, its gotta be possessed. Either that or somone put sp2 on it when
you were gone.. :-) j/k
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Tuesday, October 16, 2001 8:24 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
I'm doing a SELECT *
Should I explicitly call the fields (I'm pulling them in the order they
come
up)
-----Original Message-----
From: David Bosomworth [mailto:David@s...]
Sent: Tuesday, October 16, 2001 7:53 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Hi,
I think I had the same problem
This worked for me...
In your sql select statement, be sure to put the text fields at the end
of the select statement (and in the order you intend to access them)
For example
sql = "Select bitdata, intdata, text1data, text2data From......."
Also, once you have referenced text1Data in your asp page you won't be
able to reference it again, if you need it twice then assign it to a
variable.
hope this helps
Dave
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: 16 October 2001 12:01
To: ASP Web HowTo
Subject: [asp_web_howto] Text Fields
I've got a with quite a few fields. Has int,bits,dates these work fine-
but It has like 6 text fields- none of them show, at least not in my asp
pages. It works fine in SQL Query Analyzer, but nothing shows up from my
pages...
Any ideas why?
Oh, its on my development server, so I won't blame it on SP2 :)
(inside joke)
Message #6 by "O'Hara, Elliott M" <EMOHARA@k...> on Tue, 16 Oct 2001 08:55:27 -0400
|
|
LOL
I got my boss to buy some MS time... gunna call them and see if anyone there
knows of anything with this sp2 thing.
I hate not having it- but I hate going insane worse..
-----Original Message-----
From: Daniel O'Dorisio [mailto:daniel@o...]
Sent: Tuesday, October 16, 2001 8:44 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Nah, its gotta be possessed. Either that or somone put sp2 on it when
you were gone.. :-) j/k
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Tuesday, October 16, 2001 8:24 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
I'm doing a SELECT *
Should I explicitly call the fields (I'm pulling them in the order they
come
up)
-----Original Message-----
From: David Bosomworth [mailto:David@s...]
Sent: Tuesday, October 16, 2001 7:53 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Hi,
I think I had the same problem
This worked for me...
In your sql select statement, be sure to put the text fields at the end
of the select statement (and in the order you intend to access them)
For example
sql = "Select bitdata, intdata, text1data, text2data From......."
Also, once you have referenced text1Data in your asp page you won't be
able to reference it again, if you need it twice then assign it to a
variable.
hope this helps
Dave
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: 16 October 2001 12:01
To: ASP Web HowTo
Subject: [asp_web_howto] Text Fields
I've got a with quite a few fields. Has int,bits,dates these work fine-
but It has like 6 text fields- none of them show, at least not in my asp
pages. It works fine in SQL Query Analyzer, but nothing shows up from my
pages...
Any ideas why?
Oh, its on my development server, so I won't blame it on SP2 :)
(inside joke)
Message #7 by "Daniel O'Dorisio" <daniel@o...> on Tue, 16 Oct 2001 10:59:54 -0400
|
|
True, did you ever check and see if it was actually the page you were
redirecting to that was causing the prob?
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Tuesday, October 16, 2001 8:55 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
LOL
I got my boss to buy some MS time... gunna call them and see if anyone
there knows of anything with this sp2 thing. I hate not having it- but I
hate going insane worse..
-----Original Message-----
From: Daniel O'Dorisio [mailto:daniel@o...]
Sent: Tuesday, October 16, 2001 8:44 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Nah, its gotta be possessed. Either that or somone put sp2 on it when
you were gone.. :-) j/k
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Tuesday, October 16, 2001 8:24 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
I'm doing a SELECT *
Should I explicitly call the fields (I'm pulling them in the order they
come
up)
-----Original Message-----
From: David Bosomworth [mailto:David@s...]
Sent: Tuesday, October 16, 2001 7:53 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Hi,
I think I had the same problem
This worked for me...
In your sql select statement, be sure to put the text fields at the end
of the select statement (and in the order you intend to access them)
For example
sql = "Select bitdata, intdata, text1data, text2data From......."
Also, once you have referenced text1Data in your asp page you won't be
able to reference it again, if you need it twice then assign it to a
variable.
hope this helps
Dave
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: 16 October 2001 12:01
To: ASP Web HowTo
Subject: [asp_web_howto] Text Fields
I've got a with quite a few fields. Has int,bits,dates these work fine-
but It has like 6 text fields- none of them show, at least not in my asp
pages. It works fine in SQL Query Analyzer, but nothing shows up from my
pages...
Any ideas why?
Oh, its on my development server, so I won't blame it on SP2 :)
(inside joke)
Message #8 by "Daniel O'Dorisio" <daniel@o...> on Tue, 16 Oct 2001 11:00:14 -0400
|
|
Btw.. Let me know what it is.. This is definitely something I wanna hear
about:-)
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Tuesday, October 16, 2001 8:55 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
LOL
I got my boss to buy some MS time... gunna call them and see if anyone
there knows of anything with this sp2 thing. I hate not having it- but I
hate going insane worse..
-----Original Message-----
From: Daniel O'Dorisio [mailto:daniel@o...]
Sent: Tuesday, October 16, 2001 8:44 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Nah, its gotta be possessed. Either that or somone put sp2 on it when
you were gone.. :-) j/k
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Tuesday, October 16, 2001 8:24 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
I'm doing a SELECT *
Should I explicitly call the fields (I'm pulling them in the order they
come
up)
-----Original Message-----
From: David Bosomworth [mailto:David@s...]
Sent: Tuesday, October 16, 2001 7:53 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Hi,
I think I had the same problem
This worked for me...
In your sql select statement, be sure to put the text fields at the end
of the select statement (and in the order you intend to access them)
For example
sql = "Select bitdata, intdata, text1data, text2data From......."
Also, once you have referenced text1Data in your asp page you won't be
able to reference it again, if you need it twice then assign it to a
variable.
hope this helps
Dave
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: 16 October 2001 12:01
To: ASP Web HowTo
Subject: [asp_web_howto] Text Fields
I've got a with quite a few fields. Has int,bits,dates these work fine-
but It has like 6 text fields- none of them show, at least not in my asp
pages. It works fine in SQL Query Analyzer, but nothing shows up from my
pages...
Any ideas why?
Oh, its on my development server, so I won't blame it on SP2 :)
(inside joke)
Message #9 by "O'Hara, Elliott M" <EMOHARA@k...> on Tue, 16 Oct 2001 11:44:00 -0400
|
|
Any Response.Redirect to a page on that server crashed with a generic 500
error
There where no problems with the pages... They loaded fine if you went to
them manually...
the URL would show the page that you were redirecting to at times, at others
it would crash on the page with the Redirect command.
I tried a Response.Redirect("http://www.microsoft.Com") and it worked fine
but
Response.Redirect("../WhereIwannabe.asp") crashed
so I tried the absolute for the same file
Response.Redirect("http://myserver/whereIwannabe.asp")
and that crashed as well
One thing I didn't try (didn't think of it) was redirecting from another
server to it- just to see...
When I loaded sp2 I noticed in the event log, every time a ASP page was hit
I got an event in my application log
Source was ASP Pages
Description Was Service started
then I'd get a service stopped
that never happened before the load of sp2, and it hasn't happened since i
"fixed" it...
Kinda wierd huh?
-----Original Message-----
From: Daniel O'Dorisio [mailto:daniel@o...]
Sent: Tuesday, October 16, 2001 11:00 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
True, did you ever check and see if it was actually the page you were
redirecting to that was causing the prob?
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Tuesday, October 16, 2001 8:55 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
LOL
I got my boss to buy some MS time... gunna call them and see if anyone
there knows of anything with this sp2 thing. I hate not having it- but I
hate going insane worse..
-----Original Message-----
From: Daniel O'Dorisio [mailto:daniel@o...]
Sent: Tuesday, October 16, 2001 8:44 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Nah, its gotta be possessed. Either that or somone put sp2 on it when
you were gone.. :-) j/k
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: Tuesday, October 16, 2001 8:24 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
I'm doing a SELECT *
Should I explicitly call the fields (I'm pulling them in the order they
come
up)
-----Original Message-----
From: David Bosomworth [mailto:David@s...]
Sent: Tuesday, October 16, 2001 7:53 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Text Fields
Hi,
I think I had the same problem
This worked for me...
In your sql select statement, be sure to put the text fields at the end
of the select statement (and in the order you intend to access them)
For example
sql = "Select bitdata, intdata, text1data, text2data From......."
Also, once you have referenced text1Data in your asp page you won't be
able to reference it again, if you need it twice then assign it to a
variable.
hope this helps
Dave
-----Original Message-----
From: O'Hara, Elliott M [mailto:EMOHARA@k...]
Sent: 16 October 2001 12:01
To: ASP Web HowTo
Subject: [asp_web_howto] Text Fields
I've got a with quite a few fields. Has int,bits,dates these work fine-
but It has like 6 text fields- none of them show, at least not in my asp
pages. It works fine in SQL Query Analyzer, but nothing shows up from my
pages...
Any ideas why?
Oh, its on my development server, so I won't blame it on SP2 :)
(inside joke)
emohara@k...
$subst('Email.Unsub')
|
|
|
View Cart
