On Feb 16, 9:21 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> Ted wrote:
>
> <snipped good stuff to save electrons>
> <ditto> ;-)
>
>
> Hi, Ted,
>
> I don't do ASP.NET, but I (think I was) able to understand your code.
>
> A couple of things:
>
> In your stored proc, 'ss' should be in single quotes since it's text
> (sorry - missed that before).
>
Ah, OK. I'll check that when I get back.

> Also, in your SELECT statement for SqlDataSource2, what would be in @ss?

@ss will contain a string.

> You're doing a LIKE statement looking for text within a column of
> text, so it should be something like
>
> '%i want this%'
>
> Also, since it's a string, SQL indicated it should be within single
> quotes, as indicated above.
>
> Also, I don't see where you are checking for any errors from MySQL. I
> don't know how to do it in ASP.NET - but you should always be checking
> the results for any errors. In PHP, for instance, the result for a
> query is false when it fails, and mysql_error() retrieves the error text.
>
ASP.NET 2 (I don't know about earlier versions of .NET) has a number
of default validators and supports creation of custom validators. I
haven't shown them because that will be something I develop and test
after I get the basic connectivity working. I have used C++ and Java
as my main programming languages for over 15 years, and I've used a
number of different application frameworks and UI libraries (curses,
MFC, Borland's VCL, &c.) and I am still learning .NET myself
(leveraging obvious similarities with the other libraries/frameworks
I've used). It would be so easy doing this manually in Java with
JDBC! Maybe that is just an impression due to comparing what I have
done so often in the past to what I am trying to learn how to do.

> <snip>
> One of these days I'm going to have to learn ASP.NET. But I'm still
> stuck maintaining some VBScript sites :-)
>
If you believe the hype from MS, it is worth it. The references I
have for it make it seem like the greatest thing since sliced bread
(but then, I would kill anyone who shoved sliced bread into my
computer ;-). These references DO make a number of compelling
arguments about the benefits of ASP.NET 2. But I am not yet
convinced, but maybe after I get as comfortable with it as I am with
MFC, VCL, Java and all its wonderful libraries, ...

I don't envy you having to work with VBScript. Too bad you can't
upgrade them to at least use Perl or PHP for the ASP pages. Yes, I
have taken a look at PHP, and have toyed with it a bit, but I haven't
had the time to work seriously with it. Thus, if time is of the
essence and I need powerful scipting, I tend to resort to Perl (I like
Perl even though I find some of it quite obtuse, but it is hard to
beat C++ ;-).

Thanks again,

Ted