|
 |
asp_databases thread: inString Function??
Message #1 by Dillon Bac Say Ron <dillon_bac@y...> on Tue, 9 Oct 2001 05:03:24 -0700 (PDT)
|
|
Hello there,
Currently I was working in ASP application, the error
message showed me that "invalid support instring
function". It was able to work in Access database but
not in SQL server.
I was wondering if anyone could help me or refer me to
any resource in regard the instring function to work
in SQL 2000 server.
Thanks in advance.
Message #2 by "Dillon" <bacsr@s...> on Tue, 9 Oct 2001 20:34:11 +0800
|
|
Hello there,
Currently I was working in ASP application, the error
message showed me that "invalid support instring
function". It was able to work in Access database but
not in SQL server.
I was wondering if anyone could help me or refer me to
any resource in regard the instring function to work
in SQL 2000 server.
Thanks in advance.
Message #3 by "Daniel O'Dorisio" <daniel@o...> on Tue, 9 Oct 2001 08:25:14 -0400
|
|
Look in the sql books on line, I don't think instring is a valid SQL
function.
Are you using it on the sql server or in asp code?
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: Dillon Bac Say Ron [mailto:dillon_bac@y...]
Sent: Tuesday, October 09, 2001 8:03 AM
To: ASP Databases
Subject: [asp_databases] inString Function??
Hello there,
Currently I was working in ASP application, the error
message showed me that "invalid support instring
function". It was able to work in Access database but
not in SQL server.
I was wondering if anyone could help me or refer me to
any resource in regard the instring function to work
in SQL 2000 server.
Thanks in advance.
daniel@o...
$subst('Email.Unsub')
Message #4 by "Dillon" <bacsr@s...> on Tue, 9 Oct 2001 21:00:00 +0800
|
|
I'm using a inString to finding and cut out some characters crap in asp code
against sql server for data manipulation purpose.
It works fine in Access database. Any comments?
----- Original Message -----
From: Daniel O'Dorisio <daniel@o...>
To: ASP Databases <asp_databases@p...>
Sent: Tuesday, October 09, 2001 8:25 PM
Subject: [asp_databases] RE: inString Function??
> Look in the sql books on line, I don't think instring is a valid SQL
> function.
>
> Are you using it on the sql server or in asp code?
>
> daniel
>
> --------------------------
> Daniel O'Dorisio
> daniel@o...
> www.odorisio-networks.com
> --------------------------
>
> -----Original Message-----
> From: Dillon Bac Say Ron [mailto:dillon_bac@y...]
> Sent: Tuesday, October 09, 2001 8:03 AM
> To: ASP Databases
> Subject: [asp_databases] inString Function??
>
>
> Hello there,
> Currently I was working in ASP application, the error
> message showed me that "invalid support instring
> function". It was able to work in Access database but
> not in SQL server.
> I was wondering if anyone could help me or refer me to
> any resource in regard the instring function to work
> in SQL 2000 server.
>
> Thanks in advance.
>
>
>
Message #5 by "Daniel O'Dorisio" <daniel@o...> on Tue, 9 Oct 2001 09:01:50 -0400
|
|
Show the actual code.
daniel
--------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
--------------------------
-----Original Message-----
From: Dillon [mailto:bacsr@s...]
Sent: Tuesday, October 09, 2001 9:00 AM
To: ASP Databases
Subject: [asp_databases] RE: inString Function??
I'm using a inString to finding and cut out some characters crap in asp
code against sql server for data manipulation purpose. It works fine in
Access database. Any comments?
----- Original Message -----
From: Daniel O'Dorisio <daniel@o...>
To: ASP Databases <asp_databases@p...>
Sent: Tuesday, October 09, 2001 8:25 PM
Subject: [asp_databases] RE: inString Function??
> Look in the sql books on line, I don't think instring is a valid SQL
> function.
>
> Are you using it on the sql server or in asp code?
>
> daniel
>
> --------------------------
> Daniel O'Dorisio
> daniel@o...
> www.odorisio-networks.com
> --------------------------
>
> -----Original Message-----
> From: Dillon Bac Say Ron [mailto:dillon_bac@y...]
> Sent: Tuesday, October 09, 2001 8:03 AM
> To: ASP Databases
> Subject: [asp_databases] inString Function??
>
>
> Hello there,
> Currently I was working in ASP application, the error
> message showed me that "invalid support instring
> function". It was able to work in Access database but
> not in SQL server.
> I was wondering if anyone could help me or refer me to
> any resource in regard the instring function to work
> in SQL 2000 server.
>
> Thanks in advance.
>
>
>
daniel@o...
$subst('Email.Unsub')
Message #6 by "Tomm Matthis" <matthis@b...> on Tue, 9 Oct 2001 09:47:31 -0400
|
|
Show the code...
-- Tomm
> -----Original Message-----
> From: Dillon [mailto:bacsr@s...]
> Sent: Tuesday, October 09, 2001 8:34 AM
> To: ASP Databases
> Subject: [asp_databases] inString Function?
>
>
> Hello there,
> Currently I was working in ASP application, the error
> message showed me that "invalid support instring
> function". It was able to work in Access database but
> not in SQL server.
> I was wondering if anyone could help me or refer me to
> any resource in regard the instring function to work
> in SQL 2000 server.
>
> Thanks in advance.
>
>
>
>
> $subst('Email.Unsub')
>
>
Message #7 by "Tomm Matthis" <matthis@b...> on Tue, 9 Oct 2001 09:53:46 -0400
|
|
There is no instring function in SQL. Check BOL for the ussage of CHARINDEX
(for searching for one character) or PATINDEX for finding a pattern (or
string).
-- Tomm
> -----Original Message-----
> From: Dillon [mailto:bacsr@s...]
> Sent: Tuesday, October 09, 2001 9:00 AM
> To: ASP Databases
> Subject: [asp_databases] RE: inString Function??
>
>
> I'm using a inString to finding and cut out some characters crap in asp code
> against sql server for data manipulation purpose.
> It works fine in Access database. Any comments?
>
> ----- Original Message -----
> From: Daniel O'Dorisio <daniel@o...>
> To: ASP Databases <asp_databases@p...>
> Sent: Tuesday, October 09, 2001 8:25 PM
> Subject: [asp_databases] RE: inString Function??
>
>
> > Look in the sql books on line, I don't think instring is a valid SQL
> > function.
> >
> > Are you using it on the sql server or in asp code?
> >
> > daniel
> >
> > --------------------------
> > Daniel O'Dorisio
> > daniel@o...
> > www.odorisio-networks.com
> > --------------------------
> >
> > -----Original Message-----
> > From: Dillon Bac Say Ron [mailto:dillon_bac@y...]
> > Sent: Tuesday, October 09, 2001 8:03 AM
> > To: ASP Databases
> > Subject: [asp_databases] inString Function??
> >
> >
> > Hello there,
> > Currently I was working in ASP application, the error
> > message showed me that "invalid support instring
> > function". It was able to work in Access database but
> > not in SQL server.
> > I was wondering if anyone could help me or refer me to
> > any resource in regard the instring function to work
> > in SQL 2000 server.
> >
> > Thanks in advance.
> >
> >
> >
>
>
> $subst('Email.Unsub')
>
Message #8 by "Dillon" <bacsr@s...> on Tue, 9 Oct 2001 23:44:32 +0800
|
|
I managed to extract the character starting at the specific position of the
specified length by replaced the "inStr" with "subStr" function.
Thanks everyboby up there.
----- Original Message -----
From: Daniel O'Dorisio <daniel@o...>
To: ASP Databases <asp_databases@p...>
Sent: Tuesday, October 09, 2001 9:01 PM
Subject: [asp_databases] RE: inString Function??
> Show the actual code.
>
> daniel
>
> --------------------------
> Daniel O'Dorisio
> daniel@o...
> www.odorisio-networks.com
> --------------------------
>
> -----Original Message-----
> From: Dillon [mailto:bacsr@s...]
> Sent: Tuesday, October 09, 2001 9:00 AM
> To: ASP Databases
> Subject: [asp_databases] RE: inString Function??
>
>
> I'm using a inString to finding and cut out some characters crap in asp
> code against sql server for data manipulation purpose. It works fine in
> Access database. Any comments?
>
> ----- Original Message -----
> From: Daniel O'Dorisio <daniel@o...>
> To: ASP Databases <asp_databases@p...>
> Sent: Tuesday, October 09, 2001 8:25 PM
> Subject: [asp_databases] RE: inString Function??
>
>
> > Look in the sql books on line, I don't think instring is a valid SQL
> > function.
> >
> > Are you using it on the sql server or in asp code?
> >
> > daniel
> >
> > --------------------------
> > Daniel O'Dorisio
> > daniel@o...
> > www.odorisio-networks.com
> > --------------------------
> >
> > -----Original Message-----
> > From: Dillon Bac Say Ron [mailto:dillon_bac@y...]
> > Sent: Tuesday, October 09, 2001 8:03 AM
> > To: ASP Databases
> > Subject: [asp_databases] inString Function??
> >
> >
> > Hello there,
> > Currently I was working in ASP application, the error
> > message showed me that "invalid support instring
> > function". It was able to work in Access database but
> > not in SQL server.
> > I was wondering if anyone could help me or refer me to
> > any resource in regard the instring function to work
> > in SQL 2000 server.
> >
> > Thanks in advance.
|
|
|
View Cart
