Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by Kcarson

  1. Another consideration if he wants to be able to do the query without having to remember to type in the year each time would be to create views that are named based on the year and search only through that year. So you would have tablename2006, tablename 2005, tablename 2004, etc. That way all the data is still stored in one place which will be much easier to manipulate later on or if you need to do full reports on all years rather than just one.
  2. Kcarson

    IE 7 and CSS

    Thought you all might be interested in Microsoft's comments regarding their CSS compatability in their upcoming IE 7.http://msdn.microsoft.com/library/default...._css_compat.asp
  3. I believe you can just list the three types one right after the other meaning:CREATE TRIGGER Recount_Num_Keywords AFTER UPDATE, INSERT, DELETE OF ClientID ON ClientstoKeywordsBEGINUPDATE Clients SET NumKeywords (SELECT COUNT(*) FROM ClientsToKeywords WHERE ClientID = new.ClientIDENDI am not positive though, so you might just give it a try. This was based off of some old documentation I read for Oracle.
  4. Another disadvantage of Server Side for some sites is that it can bog down the server itself because it will have to do all of the processing versus letting the user's computer do some of it. This isn't a huge factor for most sites, but should be noted in the conversation at least.
  5. Kcarson

    After a date

    What are the column types you are storing the dates in? Is it defined as a datetime column?
  6. There is also private SSL's from what I understand that you can create yourself, but then you must give the SSL personally to whoever will use your site and they will have to install it on their end to. (I don't know much more about this as it is what the network crew at my company told me when I inquired one day. I just asked how we could create a secure link between us and our customer, and they said we can do a private or public cert, the first is free and takes 15 minutes to create but requires them to install the cert on their side as well. The second cost a couple of hundred and takes a few hours, but doesn't require any work on the customer's part. But I am not a hundred percent sure of the accuracy of their statement).Also, Verisign (http://www.verisign.com/) is a very popular place to get a public SSL
  7. Just about, you might need to write it varchar(10) or whatever. Here is a link to better describe it and the possible date formats.http://platinum.intersystems.com/csp/docbo...EY=RSQL_convert
  8. All it takes is 30 posts. But as he mentioned its value is very debatable considering someone with 30 posts has the same ranking as someone with 500....not to mention, most people (including me) do not feel that a member's value lies only in the number of posts, but in the value of each post.In some cases, rankings like these promote post wars, where people begin posting comments that are not helpful to the community but are only made to increase their count. Luckily we have been able to avoid that for the most part here.
  9. Kcarson

    Dynamic Menu's

    Ok, so it is an if statement checking to see what page you are on in order to decide which sub-menu to display. Makes enough sense. Let the fun begin now....(meaning now I can start whether it be with Shinta or Skemcin's method)
  10. Kcarson

    page layout

    Here you go:http://www.php.net/downloads.phpThe site has plenty of info on PHP...since it is a PHP only site
  11. Check out this link and if you still have questions let us know:http://www.w3schools.com/ado/ado_intro.asp
  12. I would also add:1. Too many linked images on menu and home page2. Linked images are inconsistent in size and shapeBut first priority would be the frames and size of header
  13. Ok, I know that it is probably bad practice to do this (refer people to other forums that is), but I doubt any of us will know specifically what is going on...so try this, go to the forums on mysql.com, here is the linkhttp://forums.mysql.com/Since that is all they talk about there, they should definitely be able to help you. They even have a section for installs only.
  14. Kcarson


    An interpreter. as boen_robot said, for Javascript it is a browser, for ColdFusion, PHP, ASP, and ASP.NET it is their respective applications. That is why one of the first things mentioned for those scripting languages is installing the necessary application to run the scripts. Due to this, scripting languages generally take longer to run than programming languages because a programming language has already been compiled to machine code and is made as efficient as possible, but a scripting language must be interpreted to machine code and then run...just one extra step that compiled code doesn't have to deal with. The difference in time between the two though will not be significant until you start getting into large programs.The advantage of scripting languages is that it is easier to make changes and run through and test them, because you don't have to re-compile after each change, where as a programming language requires a re-compile, which if your program has a lot of pieces can take a while and is definitely a nuissance when making changes frequently during development or making a small change in one object out of 100's and having to recompile it all as a result.Finally, one of the big disadvantages with scripting languages is that the code is available for all to see, although from what ASPNetGuy has said in other posts, I think ASP.NET allows you to do some compiling, but I am not sure on that.------Eric, as for how much skill it takes, look into LISP, its a scripting language but I guarantee you that a beginner would be lost...I was for a week or two when I messed with it, and I had taken quite a few programming classes. And if I hadn't had programming experience it would have taken me twice as long. On the flip side, I have seen people with no experience write programs in VB and even some simple ones in C/C++. I think the skill debate boils down to what you are using and what you are trying to do. Anything can be easy or hard depending on the task and the tool.
  15. Kcarson


    or if you are wanting to place it on your website so that others can link to it to download (be careful, legally that is), you would do this:<a href="FileLocation.mp3"></a>Where FileLocation.mp3 is the name and location of your song.
  16. Kcarson

    Dynamic Menu's

    Ahh...I knew it wasn't that difficult. Thanks for the site, it looks like it should work like a charm. I will play around with it more later on, but I believe that it should be enough to help me get the menu section just right.
  17. Kcarson


    I thought the main difference between scripting languages and programming languages is that programming languages are compiled code, where as scripting languages are interpreted.And I do agree that scripting languages do take skill to use, if they didn't you wouldn't see ASP/ASP.NET developers getting paid so well.
  18. Well, as for languages, you are definitely going to need to know the following:1. HTML/XHTML2. CSS3. Javascript4. SQL5. Server Side Language -either PHP, ASP, or ASP.NETMy suggestion is that you spend some time familiarizing yourself with the capabilities of each of these languages and then spend a significant amount of time planning out your project. If you do it right, the code should will be much simpler to write and maintain.I would also suggest you spend a good amount of time looking into how to design a database as that will be an important aspect of your project and a poor database design will cause headaches and problems throughout the rest of the project.I am sure others here will have more suggestions, but this is a starting point at least that I think most will agree with.
  19. Kcarson

    Dynamic Menu's

    So you do just use SSI's and then in the SSI you would call the menu from a SQL table?I guess then I would have to do something like use if statements for each menu option to determine if I needed to show the sub-menu for that particular option.And use this kind of logic for each menu option?If that is the case, then I wouldn't actually have to use a SQL call, but I could just include the necessary pieces in the PHP/ASP code itself, but before I truly go down this path, I want to be sure there is not an easier way.By the way Chocolate570, you accidentally posted the same URL for PHP and SQL, but I know what you meant
  20. Kcarson

    Dynamic Menu's

    I am finally getting time to really devote to my site, and as I plan out the necessary steps I was wondering if someone could help me with this.On the home page will be a menu, such as:HomeReferencesCalendarPicturesContact UsEtc.Now when people go to each page, for instance Pictures, I want it to look like this:HomeReferencesCalendarPictures--Album 1--Album 2--Album 3--etc.Contact UsEtc.So, I had planned on using SSI's to do the menu so that it will be easy to maintain as the site grows, but do I need to create multiple SSI's for each page, or can I do this dynamically with PHP, ASP, or ASP.net? And if so, can sombody point me in the right direction?Thanks.
  21. Kcarson

    VXML tutorial

    Well I can't speak for the creator's/maintainer's of this site, but I have noticed that they release new tutorials every once in a while, so I would say yes they probably do have plans for more tutorials in emerging languages. As for which ones, that is completely up to them.
  22. No worries....I only remember because that statement stuck in my head for some odd reason when I read it the first time long ago.
  23. The stats are from user's visiting the w3schools website, which is the reason the numbers are biased, and they say so
  24. You should be able to use the max/min functions. You would do it something like this:SELECT MAX(StartDt), MIN(EndDt)FROM Table1
  25. It sounds to me like he wants the image to link to a new page that is outside of the existing frames. Or to put it another way, when the user clicks on the image, it doesn't open it up inside the frame, but opens it up in the entire window.Matt, Is this correct?
  • Create New...