Re: Cold Fusion vs. VS .net 2005

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

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: Cold Fusion vs. VS .net 2005
    ... sure what he's talking about as I'm not familiar with web programming: ... bits of SQL into your web forms, ... This is nothing to do with .NET, this is to do with good database design. ...
    (microsoft.public.vsnet.general)
  • Re: how to put an app on the web
    ... > Several years ago I wrote a database for use by the Master Naturalist ... I have not done any web programming, ... > into a .dll and deploying it through the web would be greatly appreciated. ...
    (borland.public.delphi.non-technical)
  • IE application falls back to login screen
    ... I am using a web based application (intranet). ... application and database I have to log in through a log-in screen. ... when I am supposed to enter a date by selecting it from a calendar) I am not an expert on web programming but the application must be java based or something. ...
    (microsoft.public.windowsxp.help_and_support)
  • Form submission Encoding Problem - saving Japanese text to the database
    ... Am a new bie to web programming ... am using a servlet to retrieve field values from a web form to save ... them to the database ... in short implementing user input in laguage other than english.. ...
    (comp.lang.java.programmer)