SELECT client_companyname,client_password FROM berforts.clients WHERE client_companyname='#FORM.client_username#' AND client_password='#FORM.client_password#' CHARSET="AlphaNumeric" UCASE="No" RETURNVARIABLE="pword" > SELECT Count(client_companyname) AS countcompanies FROM clients WHERE client_companyname = "#FORM.client_companyname#" INSERT INTO clients (client_firstname, client_surname, client_companyname, client_position, client_telephone, client_mobile, client_email, client_password) VALUES ( '#FORM.client_firstname#' NULL , '#FORM.client_surname#' NULL , '#FORM.client_companyname#' NULL , '#FORM.client_position#' NULL , '#FORM.client_telephone#' NULL , '#FORM.client_mobile#' NULL , '#FORM.client_email#' NULL , '#pword#' ) SELECT client_ID from clients WHERE client_companyname = "#FORM.client_companyname#" INSERT INTO directories (directoryname) VALUES ( '#FORM.client_companyname#' NULL ) Hi there, i have registered with the Berforts website. Here are my details: Name: #FORM.client_firstname# #FORM.client_surname# E-Mail: #FORM.client_email# Company Name: #FORM.client_companyname#----- Position: #FORM.client_position#----- Telephone: #FORM.client_telephone#----- Mobile: #FORM.client_mobile#----- If you'd like to modify the new user's permissions click the url below into your browser to adjust their user settings. http://www.berforts.co.uk/clients/administration.cfm?recordID=#getrecordid.client_ID# When you are ready to approve this user click reply and edit this e-mail so it just shows the text below: --------------------------------- Hi #FORM.client_firstname#, Thank you for registering with Berforts, below is your login details so you can see the documents that are appropriate to your company, be sure to check back regularly as we are constantly updating our documents. Username: #FORM.client_companyname# Password: #pword# Berforts:: Upload Section
Berforts HOME
SERVICES		 divider GET QUOTE
UPLOAD ARTWORK		 divider
RECENT WORK
OFFER OF MONTH
ABOUT / CONTACT 		divider Paint Pot
trans trans trans
divider
Services Services
GET QUOTE
doubleline

Login with your username and password here. If you do not have these please
fill in the form below and you will receive an email from Berforts shortly with
your password.

*Your Name:
*Company Name:
*Job Name:
*Quantity:
*Finished Size: W: mm    H: mm
*Orientaion: Landscape Portrait
*Digital Proofs: High Res Low Res
*Materials:
*Printing: Black Only
4 Colour
Specials
*Finishing: Stitched
Perfect Bound
Folded
*Printing: Machine Seal
Matt Laminated
Gloss Laminated
Foil Blocking % Covered
Spot UV % Covered
*Delivery Address:
*Additional Requirements:
*Quote Delivery: Email
Fax
Post
   
 


QUOTE HELP
doubleline

Please be aware that, depending on your internet connection, large files may take a while to upload.

You will be informed when your upload has been successful. If the icon at the top right corner of your browser is moving, then it's uploading.

Do not click 'Upload' again as it will start from the beginning.

Example: On a standard 512k connection the upload speed is around 16k/sec. Uploading a 100mb file would then take around 1hr 46min.
Company Registration No 05501856
VAT Registered Number: 86295967
Registered Office: 17 Burgress Road, Ivyhouse Lane, Hastings, East Sussex, TN35 4NR, UK
© Berforts Limited 2007. All Rights Reserved
Web design, development & hosting by Purple Lettuce