Questions & Answers

Q: I bought your Form 1 Builder MYSQL software and so far everything is working great! Thanks much. One last tricky part and then I'll be complete. My t-shirt company allows selection of size, color, quantity, and personalized message printed on the shirt. I am using the code processing option for drop-down select for "size," drop-down select for "color," drop-down select for "quantity," and text entry for the "personalized_message." After these are processed by Form 1 I get the e-mail message and the SQL database entry and they are both working great. However, after processing I need to set up a pointer to my VirtueMart shopping basket that includes a subset of the same variables that have already been processed (I only need size, color, and quantity....I'll get the personalized_message from the SQL database entry). I am using the "$thankurl" as the pointer to my shopping basket after being processed by Form1, but I don't think the values are intact and being passed through. My "$thankurl" looks like the following: $thankurl = "http://www.mydomain.com/index.php?size={$size}&color={$color}&quantity={$quantity}&flypage=shop.flypage&page=shop.cart&manufacturer_id=2&category_id=9&func=cartAdd&option=com_virtuemart&Itemid=26&lang=en"; If a customer chooses size=3, color=orange, and quantity=15, then I need my $thankurl to pass these values through the $thankurl variable. I cannot change the syntax of the VirtueMart shopping cart pointer or else it will not work. Is this possible? Am I doing something wrong? How can I make it work? Thank you very much for your help,

A: You should be able to see the values in the url if they are passed, but they will not be because the variables cannot be extracted. You need to set up a script to extract the variables either from the database or the post variables. Then set your thankyou url to call the script which will then pass the varibles to the cart url.

Question and Answer Item 10618 - Browse All Question and Answer Items

Q: Please outline the cost of your system to cover 90 employees and the ability to expand as we do.

A: You can freely add as many staff as required to the Scheduler. Licensing is based on the number of users (ie people actually using the software, setting it up and running it) and the type of use. If there is just 1 user and the use is within the business (ie not consulting to other businesses) then a single user non commercial license is suitable, the cost for this type of license is US$68.00. You can assess further detail from https://bizpep.com/shiftscheduler.html .

Question and Answer Item 10617 - Browse All Question and Answer Items

Q: Do you have model regarding operating and financial leverage?

A: We do not have a specific model for this area. All available models can be accessed form the Software and Models folder at http:// bizpep.com .

Question and Answer Item 10616 - Browse All Question and Answer Items

Q: I'm having hard time changing the fields in blue as opposed to the answers given int FAQ. Can you please tell me how can I edit some names in the blue cells?

A: On the Input sheet step the cursor to a blue label cell (if you click it the hyperlink activates so you need to step) ie B13 Business Revenue and then type in the new label. The same can be done in blue label cells on the Results sheets.

Question and Answer Item 10615 - Browse All Question and Answer Items

Q: I've checked out your help files and haven't been able to find what I need. I'm getting the Error MySQL email....and I noticed the email have the information listed with no "_" in it...and my fields in my mySQL database and my form fields have "_" instead of spaces. For some reason could this mean the data is being sent to the database wrong? I have labels set up in the html, is this an issue? I've used your program before on another site and have had no issues...so I'm confused why it's not working.

A: The email you receive is modified for human display ie the _ are replace by spaces. When a form field name includes a _ the _ should also be used in the database field name. From a quick look at your form it appears ok. The MYSQL error email indicates that the data cannot be added the specified database table. Recheck MYSQL Server Name, MYSQL User Name, MYSQL User Password, MYSQL Database Name, MYSQL Table Name. These must match existing settings in the MYSQL database. Also recheck that the existing table (MYSQL Table Name) has field names that correspond to form field names and text variable types are used. Remember if your form field is First_Name it displays as First Name in your browser but the MYSQL field must be First_Name. It is also recommended that the form is run on the same server as your MYSQL database. Also make sure that any MYSQL table fields that are not skipped can accept the MYSQL Empty Value or NULL values. If you have access to the error log files for your server you may be able to identify the problem by checking the error log entries. If you still have difficulty try stripping your form and database down to a single field ie subject to eliminate/minimize potential data mismatches and determine if it is an access or data issue.

Question and Answer Item 10614 - Browse All Question and Answer Items

<< < Page 151 152 153 154 155 156 157 158 159 160 > >>