Re: Cold Fusion vs. VS .net 2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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



"Gerry Hickman" <gerry666uk@xxxxxxxxxxxxxxxx> wrote in message
news:%23s1q06kyHHA.4476@xxxxxxxxxxxxxxxxxxxxxxx
Hi wipeout64@xxxxxxxxxxx,

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)


.

Relevant Pages

  • Re: Database design - Looking for a beginners book
    ... me how business scenarios could be turned into database objects. ... Michael Hernandez - Database Design For Mere Mortalshttp://www.amazon.com/Database-Design-Mere-Mortals-Hands-/dp/0201752840 ... He also mentioned "Seeing Data" by Rebecca Riordan ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: Cold Fusion vs. VS .net 2005
    ... sure what he's talking about as I'm not familiar with web programming: ... (referential integrity). ... 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. ...
    (microsoft.public.vsnet.general)
  • Re: RSFC advice column
    ... I've thought about the database stuff too. ... SQL would actually make ... Wrox has some pretty good books on learning basic computer stuff -- ... Mere Morlals) SQL is easy to do with a good database design. ...
    (rec.sport.football.college)
  • Database design tools - which do you like and what criteria do you use
    ... Factors in Evaluating a Database Design Tool ... Does it generate SQL for DDL deltas? ...
    (comp.databases)
  • Fixed
    ... I also found this article that gives the proper way to move system dbs in sql 2008: ... The model exists where the master states it exists. ... This is the error log prior to detaching the model database. ...
    (microsoft.public.sqlserver.server)