Really need to solve this SQL problem to finish this web site.

[Miguel Dias Moura]

Hi,

i created a dataSet in an ASP.Net page which:

1. Loads all fields from each database record.
2. Creates a new field using 2 of the existing fields: FullName = FirstName
+ ' ' + LastName
3. Loads only the record which has the same FullName as the variable Name
passed in the URL to this page.

My SQL is this:

SELECT *, FirstName + ' ' + LastName as FullName
FROM people
WHERE FirstName + ' ' + LastName = ?

and:

<Parameter Name="@FullName" Value='<%# IIf((Request.QueryString("Name") <>
Nothing), Request.QueryString("Name"), "") %>'
Type="WChar"/></Parameters></MM:DataSet>

Can you please tell me how to do this?
I know i allready asked this but until now i got no solution and i need to
solve this to finish this web site and deliver it.

I hope i was able to explain better my problem.

Thank You Very Much,
Miguel

[One Handed Man \( OHM - Terry Burns \)]

Why are you putting the Request.Querystring in a pre-render block, should it
not be in regular code with the rest of it ? IE

Value = Request.QueryString("Name")

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi,

i created a dataSet in an ASP.Net page which:

1. Loads all fields from each database record.
2. Creates a new field using 2 of the existing fields: FullName = FirstName + ' ' + LastName
3. Loads only the record which has the same FullName as the variable Name
passed in the URL to this page.

My SQL is this:

SELECT *, FirstName + ' ' + LastName as FullName
FROM people
WHERE FirstName + ' ' + LastName = ?

and:

<Parameter Name="@FullName" Value='<%# IIf((Request.QueryString("Name") <> Nothing), Request.QueryString("Name"), "") %>'
Type="WChar"/></Parameters></MM:DataSet>

Can you please tell me how to do this?
I know i allready asked this but until now i got no solution and i need to
solve this to finish this web site and deliver it.

I hope i was able to explain better my problem.

Thank You Very Much,
Miguel

[Miguel Dias Moura]

Do you know the strange thing? I tested it and everything works fine...but
when i was testing in the Dreamweaver window where i place the SQL, i was
not getting any records...have no idea why is this...but well, at least it's
working.

Thanks for eveybody help and patiente...my code is working :-)

Thanks again for your time,
Miguel

"One Handed Man ( OHM - Terry Burns )" <news.microsoft.com> wrote in message
news:Ot**************@tk2msftngp13.phx.gbl...

Why are you putting the Request.Querystring in a pre-render block, should it not be in regular code with the rest of it ? IE

Value = Request.QueryString("Name")

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi,

i created a dataSet in an ASP.Net page which:

1. Loads all fields from each database record.
2. Creates a new field using 2 of the existing fields: FullName = FirstName

+ ' ' + LastName
3. Loads only the record which has the same FullName as the variable Name passed in the URL to this page.

My SQL is this:

SELECT *, FirstName + ' ' + LastName as FullName
FROM people
WHERE FirstName + ' ' + LastName = ?

and:

<Parameter Name="@FullName" Value='<%# IIf((Request.QueryString("Name") <>

Nothing), Request.QueryString("Name"), "") %>'
Type="WChar"/></Parameters></MM:DataSet>

Can you please tell me how to do this?
I know i allready asked this but until now i got no solution and i need

to solve this to finish this web site and deliver it.

I hope i was able to explain better my problem.

Thank You Very Much,
Miguel