ASP?

Question

Post reply

ASP?

marcusl

Valued Member

Points: 63
More actions
June 25, 2003 at 9:32 am

#59281

I know the forum has a little bit of this on the XML section, but maybe a section devoted to ASP would be handy. I had a few questions on some HTML code that needs to interact with my DB
I'm a DBA newbie- learrning on the fly. Thanks for any help.

I'm a DBA newbie- learrning on the fly. Thanks for any help.

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Have you been to this site?

http://www.4guysfromrolla.com/

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

Andy Warren SSC Guru Points: 119902 More actions · Answer 2

Lots of good asp/asp.net sites, including the one Brian pointed out. We'd rather redirect readers to them than do something that isnt our strong suit. If you've got a question, post it, worst that will happen is we won't know the answer.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Hi Markus,

quote:
I know the forum has a little bit of this on the XML section, but maybe a section devoted to ASP would be handy. I had a few questions on some HTML code that needs to interact with my DB

.

post it to this forum. I've tried posting some VB, ASP and related questions to http://www.codeguru.com or http://www.p2p.wrox.com and almost never get a adequate response, if at all. Although Wrox is quite good on php related questions.

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Antares686 SSC Guru Points: 125444 More actions · Answer 4

quote:
Hi Markus,
quote:
I know the forum has a little bit of this on the XML section, but maybe a section devoted to ASP would be handy. I had a few questions on some HTML code that needs to interact with my DB
.
post it to this forum. I've tried posting some VB, ASP and related questions to http://www.codeguru.com or http://www.p2p.wrox.com and almost never get a adequate response, if at all. Although Wrox is quite good on php related questions.
Cheers,
Frank

Guess I am getting behind on CodeGuru. The only problem there I have found is the site seems to get a lot of garbage responses. Might also try

http://www.experts-exchange.com/

http://www.visualbuilder.com/

http://www.asp101.com/

or look around for sites with forums on

http://www.aspin.com/

or even try the forums on (not the best in the world as far as look and ease of use.)

http://www/planet-source-code.com

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

It might only be my impression, but forums on specific 'products' like SQL Server, Apache, MySQL seem to be more active than forums on a specific programming language.

As all repliers mentioned there are a lot of good sites out there providing you with tons of source code, which you can steal...err, learn from along with countless books on whatever language you prefer.

BTW, is Usenet an alternative for you Markus. I guess there must be several newsgroup hosted by M$. Normally MVP hang around on these.

As for James.

It seems a lot of good people on codeguru now hang around somewhere else.

Planet source code is an excellent place for code snippets. Also sourceforge.net

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

marcusl Valued Member Points: 63 More actions · Answer 6

Thanks, all, for your suggestions.

www.asp101.com seems to be the best out of all of the ones you folks listed (if anyone else is reading this thread to get some info)

marcus

I'm a DBA newbie- learrning on the fly. Thanks for any help.

geomon Old Hand Points: 316 More actions · Answer 7

Marcus,

http://www.w3schools.com has some great tutorials which is a good place to start.

http://www.aspfaq.com is not so much a tutorial site, but more geared towards troubleshooting. I have yet to experience an issue that hasn't been covered to some degree.

Here's another good reference site...

http://www.devguru.com

Dale Corey SSCrazy Eights Points: 9019 More actions · Answer 8

Personally, I use FrontPage as my authoring tool for all my ASP coding, http://www.originalyellow.com. There is a Web site called FrontPage - ASP & Database examples at http://frontpagehowto.com/. I highly recomment it. Of course, Dreamweaver is also a great authoring tool, but I find that FrontPage fits better for ASP (for obvious MS reasons).

Good luck!

All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio

Frank Kalis SSC Guru Points: 111183 More actions · Answer 9

Hi Dale,

quote:
Personally, I use FrontPage as my authoring tool for all my ASP coding, http://www.originalyellow.com. There is a Web site called FrontPage - ASP & Database examples at http://frontpagehowto.com/. I highly recomment it. Of course, Dreamweaver is also a great authoring tool, but I find that FrontPage fits better for ASP (for obvious MS reasons).

forgive me on this, but the 'best authoring tool' for ASP or HTML is something like Notepad or Ultraedit. Maybe also VisualInterDev to a certain degree. I think Frontpage or Dreamweaver both take care of a lot of things I don't want them to.

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Dale Corey SSCrazy Eights Points: 9019 More actions · Answer 10

Good morning, Frank. Welcome to Monday! Hope your weekend was as good as the rest of us! Thanks for your welcome opinion!

All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio

geomon Old Hand Points: 316 More actions · Answer 11

As far as editors go, Homesite or Dreamweaver get my votes. Both have built in FTP clients as well as SourceSafe integration, without requiring FrontPage Server extentions as FrontPage and InterDev do. FPSE's tend to make your site unstable if you have multiple content publishers, and it's harder than hell to troubleshoot issues with them.

Dreamweaver also has IntelliSense just like InterDev. It's Drag n' Drop development blows away FrontPage too. If you're still a noob, go with Dreamweaver.

Antares686 SSC Guru Points: 125444 More actions · Answer 12

I will add I have tried NetObject Fusion, Dreamweaver, Front Page, Visual Interdev, WebSmith, and a host of others I forget right now. No matter what I use I spend about 40% of the time in 100% of those applications reviewing the source code itself and opening in notepad to remove garbage headers, metatags and streamlining the code the drag and drop interface leaves behind. Many in fact leave a lot of code behind for things that were deleted and this causes a lot of page blot. Mostly I stick with VI because it is the one I am most familiar with and you never user FPSE on a production server just the test environment. Most people don't know how to use and fudge with the files directly too much, often causing metadata errors. But all in all I don't use the drag and drop interface and do the layouts in my head and type the source code (makes me a better programmer to do the code myself).

I once crossed paths with a man who asked me what application I preferred to edit my web pages with and I stated "notepad". He then told me he personally wouldn't hire me because I didn't utilize the best tools available for the job. I then turned around and stated the all come with a source code editor and that drag and drop is nice but if you don't understand the garbage left behind when you make changes and cannot streamline what the WYSIWYG interface provides without it's help then you have no reason to complain if something goes wrong and you have to scrap and start over. If you have a clue on the source code side then you are a top notch programmer as a problem can be fixed without throwing out you work. He then got huffy and said they would call if they were interested and I stated to him don't bother I would call them if I wanted the job (only time I did this).

Moral of the story is people do things differently and people view how you do things differently. Use the WYSIWYG apps but make sure you take the time to learn what the source code is doing. Sure the way I do it may be a bit more complicated for some folks but once you have been doing it awhile it becomes second nature.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 13

Hi James,

quote:
I will add I have tried NetObject Fusion, Dreamweaver, Front Page, Visual Interdev, WebSmith, and a host of others I forget right now. No matter what I use I spend about 40% of the time in 100% of those applications reviewing the source code itself and opening in notepad to remove garbage headers, metatags and streamlining the code the drag and drop interface leaves behind. Many in fact leave a lot of code behind for things that were deleted and this causes a lot of page blot. Mostly I stick with VI because it is the one I am most familiar with and you never user FPSE on a production server just the test environment. Most people don't know how to use and fudge with the files directly too much, often causing metadata errors. But all in all I don't use the drag and drop interface and do the layouts in my head and type the source code (makes me a better programmer to do the code myself).
I once crossed paths with a man who asked me what application I preferred to edit my web pages with and I stated "notepad". He then told me he personally wouldn't hire me because I didn't utilize the best tools available for the job. I then turned around and stated the all come with a source code editor and that drag and drop is nice but if you don't understand the garbage left behind when you make changes and cannot streamline what the WYSIWYG interface provides without it's help then you have no reason to complain if something goes wrong and you have to scrap and start over. If you have a clue on the source code side then you are a top notch programmer as a problem can be fixed without throwing out you work. He then got huffy and said they would call if they were interested and I stated to him don't bother I would call them if I wanted the job (only time I did this).
Moral of the story is people do things differently and people view how you do things differently. Use the WYSIWYG apps but make sure you take the time to learn what the source code is doing. Sure the way I do it may be a bit more complicated for some folks but once you have been doing it awhile it becomes second nature.

100% agreed with that.

The only negative point is, when something goes wrong, you can't blame it on the software!

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

jpipes SSChampion Points: 12230 More actions · Answer 14

Agree with Antares on this one...I use Textpad myself for all development outside of QA. It has excellent support for native and add-on toolsets, compilers, etc, and awesome regexp search and replace...I guess I've just been burned too many times by WYSIWhatever editors. I used to get so mad working in Interdev; if I accidently hit the wrong tab, clicking on Design instead of HTML (I prefer not to use drag and drop...), then Interdev would mess all my well-intentioned code up - captilizing this element and not that one, and inserting its' ID="Textbox1" crud everywhere. Eventually, I got fed up of wasting my time "unwriting" the code. Sad thing is, I've found that of all the WYSIWhatever tools I've encountered, Interdev seems to to mess things up the least!

my $0.03 i guess.