Jump to content

Kcarson

Members
  • Posts

    207
  • Joined

  • Last visited

Posts posted by Kcarson

  1. Your SELECT statement would go something like this
    SELECT * FROM tablenameWHERE YEAR(DateField) = YEAR(getDate())

    That statement would get every record from the table that was from this yearyou could also do this

    SELECT * FROM tablenameWHERE YEAR(DateField) = 2004

    to get all records from 2004...fill in the year you wish to retreive...you could have a drop down list on your application that allowed your boss to choose the year then have his selection inputed intot he SQL statement before executetion.This code is for SQL Server but I think it will work in Access too since they are both MS

    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. Is there a simple way to specify for this trigger to execute on UPDATE, INSERT, and DELETE?

    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.
  3. that is true it takes more work to do that with server side unless you are using ASP.Net. .Net allows you to fillout the form, check the form, and process the form all on the same page easily.

    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.
  4. you have to have your own SSL certificate installed on the web server.  many hosting services offer a shared SSL where your non secure url might be:http://www.iribbit.netand your secure one would be:https://www1166.ssldomain.com/iribbitBoth URLs access the same code - one is just secure/encrypted and the other is not.To get an SSL, you need to buy one from Network Solutions or XRamp - for example.  You request a certificate from your host.  They give you a file you give your SSL provider.  They give you the server install files.  You give the files to your host who then installs them.  Then you have SSL.That the only way to get https to work on your site.

    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
  5. Thanks Skemcin,How many posts does it take to get to level 3?

    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.
  6. or, I've taken what I think is an equally simple approach.
    • I start by cerating one SSI menu file.
    • On every page, I set a value at the top - <cfset section="xxxxxx">
    • In the menu SSI file, simply build the complete navigation menu - fully expanded
    • Then, in the menu SSI file, build a condition around each set of links that pertain to the respective section:
      Xxxxxxx Links<br><cfif section IS "xxxxxx">(all my links for that section)<br>(all my links for that section)<br>(all my links for that section)<br>(all my links for that section)<br><br></cfif>

    • Throw in a javascript that toggles the sections for extra measure if you like
    • Done!

    Note: the same logic can be applied with any other server side scripting language.

    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)
  7. I have tried including the navigation set up as a separate HTML page as suggested. The menu items shows up when I tested it in IE and Firefox thanks for your help.However, because I am using Dreamweaver 6 to do the coding, Dreamweaver cannot resolve the inclusion and flagged the line as error and would not display any of the rest of my design view. Would you or anybody knows how I can get around this problems ?If I use PHP include the menu, I assume I must have PHP installed in my PC. Are there any site I can download the PHP (Sorry I know next to nothing about PHP so if I have a bit of pointers I would really appreciate it.)Thanks again.

    Here you go:http://www.php.net/downloads.phpThe site has plenty of info on PHP...since it is a PHP only site :)
  8. can anyone help me how to use sql or asp.  we are having our thesis and we don't have any idea of how to connect the database to dreamweaver by using any of the two.  we also need help regarding the server because we are developing an online board exam review and we really don't have any idea of how to start the system.  we only did the design of the webpage using dreamweaver.  hope any of you can help us as soon as possible...thanks!

    Check out this link and if you still have questions let us know:http://www.w3schools.com/ado/ado_intro.asp
  9. but the 4.1.15 didnt work.

    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.
  10. Programming need compiler to convert commands into binary code as ~Shinta said , script language has no need with compiler  , so what converts commands in script into binary code  :)

    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.
  11. <bgsound src="" />try this :)

    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.
  12. People are making this too complicated. You need to know HTML and CSS, and if you want to make things hard, Javascript. There is an article on A List Apart about them here: http://www.alistapart.com/articles/hybridJust edit the CSS a bit to make it vertical.

    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.
  13. How is that?? PHP or ASP programmer don't have/need skill??? It requires a different approach/type of skill. You have probably insulted a lot of people with that comment...including me. I use ASP and ASP.Net. While they are different both do require a lot of skill.The main difference is that yes scripting languages are stripped down (some) so they have don't have as much power. But the biggest difference is OOP (Object Oriented Programming). Scripting languages do not have objects...you can break up the code into functions, etc. Other languages like JAVA, ASP.Net, C++, etc allow you to create  objects and classes and they can be easily reused on multiple pages/forms.

    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. :)
  14. 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.

  15. If I think I know what you want---then you can use the php include() function, and keep a seperate php file for the menu---meaning, you only have to change the menu in one place.As for the other thing you wanted, you'd have to use SQL and put different choices under each main column/table, and build the menu according to what you pull out of the tables. :)PHP Tutorial: http://www.w3schools.com/sql/default.aspSQL Tutorial: http://www.w3schools.com/sql/default.aspGood luck and have fun!Choco

    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 :)
  16. 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.

  17. Are there any plans for more tutorials in emerging languages, such as VXML?  I have not seen a question about this so far, although I have not read all of the posts.

    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.
  18. I don't think it's only people visiting their site, because then the results for Firefox/Netscape/Opera would be much higher in comparison to IE than they are as of now...

    The stats are from user's visiting the w3schools website, which is the reason the numbers are biased, and they say so
    Why so high Firefox figures?W3Schools is a website for people with an interest for web technologies. These people are more interested in using alternative browsers than the average user. The average user tends to use Internet Explorer, since it comes preinstalled with Windows. Most do not seek out other browsers.These facts indicate that the browser figures below are not 100% realistic. Other web sites have statistics showing that Internet Explorer is used by at least 80% of the users.
  19. this My Query"Select StartDt,EndDt from Table1"Now i will get an Recordset with collection of StartDate and EndDate, What i want  is form the recordset i want to get the MaxDate and MinDate from one of these field"i use ASP, MsAccess"i think u Understand my Problem, Help me pleaseUr Dear Ravi

    You should be able to use the max/min functions. You would do it something like this:
    SELECT MAX(StartDt), MIN(EndDt)FROM Table1

  20. You just want to open a new pagein the frame??? Or have the layout change but keep the same content?If it is the second choice then you need a server side lanaguage like ASP to do this.

    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...