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:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSource>

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.powrote in message
news:ej**************@TK2MSFTNGP05.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:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSource>

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.netschreef in bericht
news:%2****************@TK2MSFTNGP06.phx.gbl...

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

"Eric" <er*@sdsclem.powrote in message
news:ej**************@TK2MSFTNGP05.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:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSource>

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.powrote in message
news:ub**************@TK2MSFTNGP03.phx.gbl...

Thanks for replying, but i get the same error.

"sloan" <sl***@ipass.netschreef in bericht
news:%2****************@TK2MSFTNGP06.phx.gbl...

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

"Eric" <er*@sdsclem.powrote in message
news:ej**************@TK2MSFTNGP05.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:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSource>

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.netschreef in bericht
news:uj****************@TK2MSFTNGP03.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.powrote in message
news:ub**************@TK2MSFTNGP03.phx.gbl...

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

"sloan" <sl***@ipass.netschreef in bericht
news:%2****************@TK2MSFTNGP06.phx.gbl...

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

"Eric" <er*@sdsclem.powrote in message
news:ej**************@TK2MSFTNGP05.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:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSource>

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.powrote in message
news:ux****************@TK2MSFTNGP05.phx.gbl...

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

"sloan" <sl***@ipass.netschreef in bericht
news:uj****************@TK2MSFTNGP03.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.powrote in message
news:ub**************@TK2MSFTNGP03.phx.gbl...

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

"sloan" <sl***@ipass.netschreef in bericht
news:%2****************@TK2MSFTNGP06.phx.gbl.. .
THrow in an alias I think
SELECT left(field1,10) as MyAlias1 FROM [mytable]

"Eric" <er*@sdsclem.powrote in message
news:ej**************@TK2MSFTNGP05.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:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT left(field1,10) FROM [mytable]">
</asp:SqlDataSource>
>
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
>