Looking for ASP resources you guys use...
Hello All,
I am a noob to ASP & sql coding, so pardon the dumb questionâ¦
I am learning to code in ASP and am using sql in ASP to query a SQL Server DB hosted on my ISPâs server. Actually, the way I am trying to learn is to âreverse engineerâ an application I bought from someone written in ASP, running on SQL Server 2000 DB and am trying to mod it / tweek it to my specific needs.
My problem is the syntax of ASP and syntax of sql query string in ASP. I can logically break down what I want to do when it comes to to displaying data the way I need to. But the devil is in the details----I am wasting much time trying to get the syntax correct-- so the compiler does not bomb on a missing apostrophe, or missing space or an incorrectly formatted query string. As an example, Iâve spent about 3 evenings so far, trying to properly declare a couple of date variables , pull in those date variable into an ASP sql query string and have it run properly without bombing due to syntax error.
I tried Googling the terms I need answers for and there are lot of free resources / examples on the web- but so far- what Iâve found are resources that lack the detail I need to make the code run error free or the examples are so complicated I cannot understand the logic of the programmers intention with the code. Iâve tried the W3 School website---very basic and have tried looking at the MSDN siteâway too complicated yet for me.
My question to the community:
Is there a definitive online resource, website or even a detailed hard copy book that you guys use, that will spell out in detail, proper syntax to use in ASP & ASP sql query strings down to the last apostrophe and last semi-colon? I am looking for a detailed information resource for ASP that has real world working examples.
What do you guys use???
Thanks
|
