Web Hosting Vodahost    

Home Take The Royal Tour! Order Now Features Prices
Go Back   Web Hosting > BlueVoda Website Builder Forums > Forms

Notices

Forms Discussion and help related to designing and implementing forms in the BlueVoda Website Builder.

Reply
 
LinkBack Thread Tools
  #1  
Old 08-19-2007, 05:21 PM
Private First Class
 
Join Date: Aug 2007
Posts: 9
Default Linking form with db table - I am missing somthing

Hi,

I have successfully (i think) installed ABVFP and created a form entry indicating the data is to be stored in a db table.

when I submit the for the info comes to my email and i get the thank you page, but it is not going into the mysql table.

I cannot see how the two elements are connected (the form and the table that is). They are very simple test versions just one form field "name" and 3 table fields (which include the required date and ip fields) as well as the required hidden form field.

I know I am missing something in the process. I figure there should be somewhere in the ABVFP_forms table entry where I tell it which table to use?

Please any advice would be great.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 08-20-2007, 12:10 AM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 9,342
Default Re: Linking form with db table - I am missing somthing

No, there isn't. ABVFP creates a table called "Form:nr_XX" where xx is the formid asigned by ABVFP and used in the form.

Please note that if you have made any editings in your ABVFP CP regarding this form, you need EACH time to check again the "Store in Database" radio button, because it is bt default set to NOT store.
__________________
Navaldesign
Logger Lite: Low Cost, Customizable, multifeatured Login script
Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old 08-20-2007, 01:36 AM
Private First Class
 
Join Date: Aug 2007
Posts: 9
Default Re: Linking form with db table - I am missing somthing

Where should this table be located?

The only tables I see in the database are ABVFP_Form and test_table (which I created). There is a reference to the form id for my form in the ABVFP_Form table. Any other suggestions?

I am using the manual table creation approach.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old 08-20-2007, 08:58 AM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 9,342
Default Re: Linking form with db table - I am missing somthing

If, in example, the form id is 3, you should have created a table called "Form_nr_3" and you should have MANUALLY added the correct fields (defining not only field names, but also type of fields and lenghts)

If you didn't, or if the fields are not correctly setup, ABVFP will NOT store the data in it. So i suggest that you completely cancel the table, then go in ABVFP's control panel and make sure to set it to automatically create the table. Check again also the "Store in database" radio button.
__________________
Navaldesign
Logger Lite: Low Cost, Customizable, multifeatured Login script
Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5  
Old 08-20-2007, 02:05 PM
Private First Class
 
Join Date: Aug 2007
Posts: 9
Default Re: Linking form with db table - I am missing somthing

Thanks,

That is what I was missing. I will give it a try later today.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 03:36 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC7
2005-2009 VodaHost Web Hosting Your Perfect Web Host - All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176