how to use left function in a selectcommand in aspx file?

[Eric]

Hi,

i tested this sql command directly with sql server and it works:
select left(field1,10) from mytable

Now, i tried the same in aspx file: i dragged a sqldatasource control and
changed manually the select commend like this:

<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:myconn %>"
SelectCommand=" SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSour ce>

But here, i get the error:
"no field or property met with the name field1in the selected source .."(or
something)

Any way to limit the text of field 'field1' to 10 characters?

Thanks
Eric

[sloan]

THrow in an alias I think
SELECT left(field1,10) as MyAlias1 FROM [mytable]

"Eric" <er*@sdsclem.po wrote in message
news:ej******** ******@TK2MSFTN GP05.phx.gbl...

Hi,

i tested this sql command directly with sql server and it works:
select left(field1,10) from mytable

Now, i tried the same in aspx file: i dragged a sqldatasource control and
changed manually the select commend like this:

<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:myconn %>"
SelectCommand=" SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSour ce>

But here, i get the error:
"no field or property met with the name field1in the selected source
.."(or something)

Any way to limit the text of field 'field1' to 10 characters?

Thanks
Eric

[Eric]

Thanks for replying, but i get the same error.

"sloan" <sl***@ipass.ne tschreef in bericht
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

THrow in an alias I think
SELECT left(field1,10) as MyAlias1 FROM [mytable]

"Eric" <er*@sdsclem.po wrote in message
news:ej******** ******@TK2MSFTN GP05.phx.gbl...

>Hi,

i tested this sql command directly with sql server and it works:
select left(field1,10) from mytable

Now, i tried the same in aspx file: i dragged a sqldatasource control and
changed manually the select commend like this:

<asp:SqlDataSo urce ID="SqlDataSour ce1" runat="server"
ConnectionStri ng="<%$ ConnectionStrin gs:myconn %>"
SelectCommand= "SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSour ce>

But here, i get the error:
"no field or property met with the name field1in the selected source
.."(or something)

Any way to limit the text of field 'field1' to 10 characters?

Thanks
Eric

[sloan]

Use storedprocedure , or get the data, then .. fix it. (Which is what the
presentation layer is supposed to do anyways).
"Eric" <er*@sdsclem.po wrote in message
news:ub******** ******@TK2MSFTN GP03.phx.gbl...

Thanks for replying, but i get the same error.

"sloan" <sl***@ipass.ne tschreef in bericht
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

>THrow in an alias I think
SELECT left(field1,10) as MyAlias1 FROM [mytable]

"Eric" <er*@sdsclem.po wrote in message
news:ej******* *******@TK2MSFT NGP05.phx.gbl.. .

>>Hi,

i tested this sql command directly with sql server and it works:
select left(field1,10) from mytable

Now, i tried the same in aspx file: i dragged a sqldatasource control
and changed manually the select commend like this:

<asp:SqlDataS ource ID="SqlDataSour ce1" runat="server"
ConnectionStr ing="<%$ ConnectionStrin gs:myconn %>"
SelectCommand ="SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSour ce>

But here, i get the error:
"no field or property met with the name field1in the selected source
.."(or something)

Any way to limit the text of field 'field1' to 10 characters?

Thanks
Eric

[Eric]

It works if i do this:
SELECT left(n1,10) as n1 (with the same fieldname in the alias.

"sloan" <sl***@ipass.ne tschreef in bericht
news:uj******** ********@TK2MSF TNGP03.phx.gbl. ..

Use storedprocedure , or get the data, then .. fix it. (Which is what the
presentation layer is supposed to do anyways).
"Eric" <er*@sdsclem.po wrote in message
news:ub******** ******@TK2MSFTN GP03.phx.gbl...

>Thanks for replying, but i get the same error.

"sloan" <sl***@ipass.ne tschreef in bericht
news:%2******* *********@TK2MS FTNGP06.phx.gbl ...

>>THrow in an alias I think
SELECT left(field1,10) as MyAlias1 FROM [mytable]

"Eric" <er*@sdsclem.po wrote in message
news:ej****** ********@TK2MSF TNGP05.phx.gbl. ..
Hi,

i tested this sql command directly with sql server and it works:
select left(field1,10) from mytable

Now, i tried the same in aspx file: i dragged a sqldatasource control
and changed manually the select commend like this:

<asp:SqlData Source ID="SqlDataSour ce1" runat="server"
ConnectionSt ring="<%$ ConnectionStrin gs:myconn %>"
SelectComman d="SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSour ce>

But here, i get the error:
"no field or property met with the name field1in the selected source
.."(or something)

Any way to limit the text of field 'field1' to 10 characters?

Thanks
Eric

[sloan]

Oh, ok.

I was close....

Glad you figured it out.
"Eric" <er*@sdsclem.po wrote in message
news:ux******** ********@TK2MSF TNGP05.phx.gbl. ..

It works if i do this:
SELECT left(n1,10) as n1 (with the same fieldname in the alias.

"sloan" <sl***@ipass.ne tschreef in bericht
news:uj******** ********@TK2MSF TNGP03.phx.gbl. ..

>Use storedprocedure , or get the data, then .. fix it. (Which is what the
presentation layer is supposed to do anyways).
"Eric" <er*@sdsclem.po wrote in message
news:ub******* *******@TK2MSFT NGP03.phx.gbl.. .

>>Thanks for replying, but i get the same error.

"sloan" <sl***@ipass.ne tschreef in bericht
news:%2****** **********@TK2M SFTNGP06.phx.gb l...
THrow in an alias I think
SELECT left(field1,10) as MyAlias1 FROM [mytable]

"Eric" <er*@sdsclem.po wrote in message
news:ej***** *********@TK2MS FTNGP05.phx.gbl ...
Hi,
>
i tested this sql command directly with sql server and it works:
select left(field1,10) from mytable
>
Now, i tried the same in aspx file: i dragged a sqldatasource control
and changed manually the select commend like this:
>
<asp:SqlDat aSource ID="SqlDataSour ce1" runat="server"
ConnectionS tring="<%$ ConnectionStrin gs:myconn %>"
SelectComma nd="SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSour ce>
>
But here, i get the error:
"no field or property met with the name field1in the selected source
.."(or something)
>
Any way to limit the text of field 'field1' to 10 characters?
>
Thanks
Eric
>