Jump to content

Skemcin

Members
  • Posts

    2,684
  • Joined

  • Last visited

Everything posted by Skemcin

  1. You're welcome. If you get a chance, post a link when you get it worked out.Good luck.
  2. Skemcin

    Naming Conventions

    yummy - conventions - i love them . . . here are some of mine - specific to DB:Databases have no ceonvention other than to be labeled in some respect to the application to which they are designed for.Tables have a two letter prefix followed by an underscore:ac_ = accounting (i.e. ac_gl_account, ac_invoice, ac_payment)co_ = customer (i.e. co_individual, co_address)ec_ = ecommerce (i.e. ec_order, ec_order_detail, ec_shipping)whenever I have a lookup table always uses the table names seperated by an _x_ (i.e. co_individual_x_address)Columns have a three letter prefix (abbreviating the table) followed by an underscore:- co_individual- - ind_id, ind_firstname, ind_lastname, ind_date_of_birth- co_address- - add_key, add_street_one, add_street_two, add_cityall databases, table names, and columns are in single tense - no "s" on the end. The fact that it is a table/database implies that there is more than one record. What you are actually doing is defining information one at a time (just all stored together) - so you're really just looking at one thing.Record 103 is a record in the co_individual table not a record in the co_individuals table - you;re only talking about one record being stored at a time (hence singular tense). The is especially true when looking at the name of the columns - you don;t see firstnames, you see firstname.Stored Procedures again nothing to specific but again each are related to the application that they are associated with. Some three letter prefix with an underscore. "SP" is reserved by the system so we stay away from using it as a prefix.
  3. Skemcin

    Frames

    Hi and welcome to the fourm.Before I answer the question, I have ot ask why is the navigation so long. Have you ruled out a way to categorize teh navigation items? If they are categorized, then you can use a show/hide script to expand/collapse you navigation menu.Does the navigation have to be on one side only - could you break it up to be left and right or something else?Do you have a link for us to preview what you have?
  4. lol - sorry I can;t help you with teh javascript right now, but I love the preface!!
  5. welcome to the forums dinki - let us know if you find a solution.
  6. Skemcin

    span class?

    First, welcome to the forums.Second, can you post a link to what you have so far - just so we can take a look at the code and play with it.Do you have Wells Fargo budget? - Ok, just being sarcastic there, I know you just want the design concept. Post your link and I can try to see what can be done.
  7. Hey,Can you (I mean your friend) be a little more specific for each of the questions:a.) "I can't seem to create users properly."Is this being attemped through a web page application on a particular site or is this related to connecting to the database through an administration tool?b.) "And/or how do I get the people who run my package system to update?"Who are "the people" and are you(sorry, your friend) referring to finding out how to ask the hosting provider to update MySQL?Hope you (err, sorry, your friend) finds this helpful.P.S. Sorry for poking fun, I couldn't resist.
  8. Skemcin

    Alias

    nope, just stayed at a holiday inn last night!lol - actually just learning more and more from the legacy code I have to deal with on a daily basis.:)You should see some of the Stored Procedures.
  9. Skemcin

    Alias

    here's one I had to write recently. It shows how a naming convention can avoid the use of table aliases but how the colun alias make sense. this is an example for pulling data on one server - Kcarson makes an excellent point for table aliases across servers. SQL ia fun!
  10. Skemcin

    search problem

    can you have my employer double my pay, ah, lets tripple it while you're at it.suneeshaCould you just use Google's free search? It allows the developer customize the look and feel so that it looks like their site. Put this script on all your pages and you seemless site search without knowing any php, asp, or cold fusion.Just an another alternative.
  11. On the homepage, the link is under the Site Search, I would make this consistant throughout the entire site and make sure it appears there all the time.An image like this:http://www.coolinterview.com/images/comment.gifCould be placed just to the left of the text link to draw some attention to it.I think if you draw too much attention to the forum, people will skip over the tutorials all and look for an answer in the forums. For that reason, I would say keep it as blended as all the other links, but then at the conclusion of each tutorial, I'd provide a "button" or more obvious link.I don't want to add "Did you go through the tutorial yet?" to me signature!
  12. Skemcin

    Where are you?

    Google offers the technology behind this in an API that you can download.:Google Maps API
  13. Skemcin

    Alias

    There are two types of aliases that are used most frequently: column alias and table alias. Column aliases exist to help organizing output where table aliases are used to distinguish one table from another when obtaining information from two separate tables.For columns, you would use it to give the name a more readable name. For instance, I prefix all my colums with three letters (here's why). So I might forma statement like this: You will only need to worry about table name aliases when you get into JOIN statements - where you combine/query mroe than one table at a time.I will note that, if you abopt a good naming convention, most of need for table aliases can be avoided. A good convention will also keep your statements easier to read and understand. A three letter prefix will always make sure you know what "ID" you're looking at.
  14. Hi Jessica and welcome to the forums.HTML and CSS can work very nicely together. There will be some that say you should do almost everything you want to with CSS and others that say you should do an equal amount in both. So, just figure out what works best for you.Having said that, here is where you can go.First, you could do it old school - use HTML to layout your page with tables or what have you and then put your images there. The position of the image would be controlled by how your table is constructed.Secondly, you could do it new school - use HTML to simply code the page, but have CSS do the majority of the layout. This owuld mean that HTML just say here is block A, here is block B, and the CSS would say block A goes here and block B goes here - based on relative or absolute positioning.So, tables (old school) are bound by how you define them (this row, this column) so how that set up will determine where things go. Using CSS to define position binds that control to the CSS definitions. Either way, and future changes will have to be made in one place or the other - so I'd figure out which is easier for you and go that direction - but understand that the second method is the "more appropriate" technique.Finally, animation. When you say "move" do you mean you would like the image to physically move from one place on the screen to the other - or just act more like a slide show? The former will take javascript and CSS where the later could be done in Image Ready.Hope this helps.
  15. yeah its an impressive number, this forum will do very well - no doubt.
  16. Paim is right, the easiest way (programmatically) to resolve your issue to is to have php, asp, or cold fusion code written that extracts the information about your gallery (imagename, number, etc.) from a database.That woud require you to learn a scripting language, some basic sql, and some concepts around database design. All those tutorials are offered here at w3schools.com.Given what you currently know, you might be able to skip the scripting language and the database all together if you want to try some XML. You can use HTML and XML to produce the same result.XML Tutorial - Data IslandsThat tutorial will show you how you can create an XML file and call the data contained in it using HTML. I ran into a similar situation four years ago, I used this technique - it got me into XML and then later into a scripting language once I saw how much more I could do.Good Luck.
  17. post a link to the issue so we can have a look.thanks
  18. nice - now we just need to keep working on that admin/moderator to member ratio!
  19. should be as simple as using the correct defiinition of the TARGET attribute when you define the link in flash.
  20. your action attribute seems to have some incorrect coding: The parenthesis-() actually represent sqaure brackets-[]. Its seems that some code from a web forum (maybe this one) was accidently inserted into your code.
  21. sorry for not mentioning that the script goes in the popup window.Thanks Chocolate for showing it being executed as a function. I've always executed it inline on an action page - didn't think to turn it into a function for this type of use.
  22. so what is your question? my guess is that you want the contact us page to render at the same width as the homepage. You'll have to define the width of your nested <table> and <td> tags. Plus, I noticed that the parent <table> a width of 780 but a nested one is set to 800 - something needs to be adjusted there to be technically correct.
  23. at this point in time, vector art can only be rendered in flash - the closest thing in the near future is SVG on the web. you can read about its progress here:http://www.svgopen.orgEverything for now is raster-based.
  24. I take it you want to refresh the parent window - the opener? If so, here you go:
  25. hope all is well, and wish you a speedy recovery.
×
×
  • Create New...