<wipeout64@hotmail.com> wrote in message
news:469e5038$0$20590$4c368faf@roadrunner.com...
>I have an application that will need to be transferred from a desktop to
>the
> web. Currently it's written in FoxPro. A small spin-off of this
> application
> was put on the web by another programmer. He claimed he had to use cold
> fusion because Visual Studio .Net with SQL couldn't handle the open ended
> select statements. I assume he means the unmatched records. I need to
> start
> studying web design and all languages involved to put it on the web, but
> don't know where to start. I do not have time to study both VS .net and
> Cold
> Fusion.
>
> 1) Is cold Fusion better and faster than mySQL with VS .net?
> 2) Will mySQL work with both VS .net 2005 and Cold Fusion?
> 3) Is Cold Fusion easier to learn/work with than VS .net?
>
>
>

"Gerry Hickman" <gerry666uk@newsgroup.nospam> wrote in message
news:u0NmPOYyHHA.1484@TK2MSFTNGP06.phx.gbl...
> Hi,
>
>> I have an application that will need to be transferred from a desktop to
>> the
>> web. Currently it's written in FoxPro.
>
> Yuk.
>
>> A small spin-off of this application
>> was put on the web by another programmer. He claimed he had to use cold
>> fusion because Visual Studio .Net with SQL couldn't handle the open ended
>> select statements.
>
> Can you clarify exactly what an open ended select statement is?
>
> > I assume he means the unmatched records.
>
> What are they?
>
>> I need to start
>> studying web design and all languages involved to put it on the web, but
>> don't know where to start. I do not have time to study both VS .net and
>> Cold
>> Fusion.
>
> Some options would be
>
> Linux, Apache, mySQL, PHP
> Windows, IIS, SQL Server, ASP.NET
>
> You really need to choose one or the other.
>
>> 1) Is cold Fusion better and faster than mySQL with VS .net?
>
> I don't think you can use mySQL with VS.NET unless you've got a special
> driver or code it manually?
>
>> 2) Will mySQL work with both VS .net 2005 and Cold Fusion?
>
> Hard to say.
>
>> 3) Is Cold Fusion easier to learn/work with than VS .net?
>
> Unlikely, but the real problem is that Cold Fusion is not a popular
> choice, so in my view it would be a bad decision to buy into it.
>
> VS.NET is strictly Windows only, so it's a bad choice if you want to code
> cross-platform.
>
> --
> Gerry Hickman (London UK)

> I have an application that will need to be transferred from a desktop to the
> web. Currently it's written in FoxPro.

> A small spin-off of this application
> was put on the web by another programmer. He claimed he had to use cold
> fusion because Visual Studio .Net with SQL couldn't handle the open ended
> select statements.

> I assume he means the unmatched records.

> I need to start
> studying web design and all languages involved to put it on the web, but
> don't know where to start. I do not have time to study both VS .net and Cold
> Fusion.

> 1) Is cold Fusion better and faster than mySQL with VS .net?

> 2) Will mySQL work with both VS .net 2005 and Cold Fusion?

> 3) Is Cold Fusion easier to learn/work with than VS .net?

> RE: Open ended select statements - This is his exact wording, but I'm not
> sure what he's talking about as I'm not familiar with web programming:

> Things like mismatched columns make SQL joins impossible and orphaned rows
> break the required RI
> (referential integrity). We tried to normalize the DB so that we could
> leverage the .Net20 tools but were unable to do so.

"Gerry Hickman" <gerry666uk@newsgroup.nospam> wrote in message
news:%23s1q06kyHHA.4476@TK2MSFTNGP06.phx.gbl...
> Hi wipeout64@hotmail.com,
>
>> RE: Open ended select statements - This is his exact wording, but I'm not
>> sure what he's talking about as I'm not familiar with web programming:
>
> This isn't to do with "web programming", it's to do with SQL databases and
> as Mark says above, it sounds dangerous because they may be able to feed
> bits of SQL into your web forms, thereby hacking into your server.
>
>> Things like mismatched columns make SQL joins impossible and orphaned
>> rows break the required RI
>> (referential integrity). We tried to normalize the DB so that we could
>> leverage the .Net20 tools but were unable to do so.
>
> OK, well basically you have to re-design it so that it complies with
> referential integrity. However, you can still use fuzzy logic to do
> look-ups and queries.
>
> This is nothing to do with .NET, this is to do with good database design.
>
> You probably need to post your question and design to one of the database
> newsgroups and CC it to the FoxPro group - they'll be able to help you
> migrate it to mySQL or SQL Server. I don't think Visual Studio can help
> you with this until you fix the database.
>
> --
> Gerry Hickman (London UK)

"Gerry Hickman" <gerry666uk@newsgroup.nospam> wrote in message
news:OIF63SKzHHA.4928@TK2MSFTNGP03.phx.gbl...
> Hi,
>
>> Wow! Thanks for the info. But then this could happen regardless whether I
>> use ColdFusion or .net - correct?
>
> You mean the SQL injection and hacking? Yes, it can happen on all types of
> programming that allow users to submit text strings against SQL databases.
>
> A good way to deal with it is to use stored procedures and also make sure
> you set up database security properly.
>
> There's an article here that may help:
>
> http://en.wikipedia.org/wiki/SQL_injection
>
>> "Gerry Hickman" <gerry666uk@newsgroup.nospam> wrote in message
>> news:%23s1q06kyHHA.4476@TK2MSFTNGP06.phx.gbl...
>>> Hi wipeout64@hotmail.com,
>>>
>>>> RE: Open ended select statements - This is his exact wording, but I'm
>>>> not sure what he's talking about as I'm not familiar with web
>>>> programming:
>>> This isn't to do with "web programming", it's to do with SQL databases
>>> and as Mark says above, it sounds dangerous because they may be able to
>>> feed bits of SQL into your web forms, thereby hacking into your server.
>>>
>>>> Things like mismatched columns make SQL joins impossible and orphaned
>>>> rows break the required RI
>>>> (referential integrity). We tried to normalize the DB so that we could
>>>> leverage the .Net20 tools but were unable to do so.
>>> OK, well basically you have to re-design it so that it complies with
>>> referential integrity. However, you can still use fuzzy logic to do
>>> look-ups and queries.
>>>
>>> This is nothing to do with .NET, this is to do with good database
>>> design.
>>>
>>> You probably need to post your question and design to one of the
>>> database newsgroups and CC it to the FoxPro group - they'll be able to
>>> help you migrate it to mySQL or SQL Server. I don't think Visual Studio
>>> can help you with this until you fix the database.
>>>
>>> --
>>> Gerry Hickman (London UK)
>>
>>
>
>
> --
> Gerry Hickman (London UK)

> Wow! Thanks for the info. But then this could happen regardless whether I
> use ColdFusion or .net - correct?

> "Gerry Hickman" <gerry666uk@newsgroup.nospam> wrote in message
> news:%23s1q06kyHHA.4476@TK2MSFTNGP06.phx.gbl...
>> Hi wipeout64@hotmail.com,
>>
>>> RE: Open ended select statements - This is his exact wording, but I'm not
>>> sure what he's talking about as I'm not familiar with web programming:
>> This isn't to do with "web programming", it's to do with SQL databases and
>> as Mark says above, it sounds dangerous because they may be able to feed
>> bits of SQL into your web forms, thereby hacking into your server.
>>
>>> Things like mismatched columns make SQL joins impossible and orphaned
>>> rows break the required RI
>>> (referential integrity). We tried to normalize the DB so that we could
>>> leverage the .Net20 tools but were unable to do so.
>> OK, well basically you have to re-design it so that it complies with
>> referential integrity. However, you can still use fuzzy logic to do
>> look-ups and queries.
>>
>> This is nothing to do with .NET, this is to do with good database design.
>>
>> You probably need to post your question and design to one of the database
>> newsgroups and CC it to the FoxPro group - they'll be able to help you
>> migrate it to mySQL or SQL Server. I don't think Visual Studio can help
>> you with this until you fix the database.
>>
>> --
>> Gerry Hickman (London UK)
>
>