myWebBlog

Posts made in January, 2012

• Creating SQL statements from Excel Tables:

  General Information

  I was given a huge table of stuff to insert into an SQL database table, it wasnt possible to import this using load data but one of my colleagues in the office gave me a handy Excel formula to use:
  =”INSERT INTO flight_refund_country_bands SET countryname=’”&A1&”‘, band_id=”&B1
  Seems very simple now I think about it but it [...]

  Share with your friends and help out this site:

  • 
  • 
  • 
  • 
  • 
  • 
  • 
  • 
  • 
  • 
  • 

  Read More...

• jQuery Multi field required validation code snippet

  General Information

  I basically wanted a really quick validation code function that would check whether any required fields were missing and prevent the form from submitting if this were the case:

  Share with your friends and help out this site:

  • 
  • 
  • 
  • 
  • 
  • 
  • 
  • 
  • 
  • 
  • 

  Read More...