close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Multiple upload problem

Thread began 1/14/2013 10:08 am by georgina_barrett_187762 | Last modified 1/15/2013 2:38 pm by Jason Byrnes | 427 views | 4 replies |

georgina_barrett_187762

Multiple upload problem

I have a system that allows users to select a hotel then select the type of room they want and the number of days they require. (There are only 7 days as it is for a festival)

I have the hotels stored in a database and I have a list of room types and prices per day for each of these rooms. I have attached a screen shot.

I want to allow the user to select for example a twin for mon, tue and wed AND a triple for thurs and fri. The price is then stored in a database. (I have attached a screenshot of how it is stored)

I have added a repeat region which I thought would do this but it just stores all the information in one row for example if I select single monday and tuesday and a double tuesday and wednesday it stores the single price on monday the double price on the tuesday (it discards the monday single price) and the double price on the wednesday.

Attached Files
hoteltype1.zip
Sign in to reply to this post

Jason ByrnesWebAssist

you have a repeat region inside the repeat selection. that was added by the multiple update behavior.

you need to remove the repeat region, only the repeat selection behavior is needed.

Sign in to reply to this post

georgina_barrett_187762

I have removed the repeat region and left the repeat selection but now it doesn't repeat. I have attached a screenshot and the file.

Attached Files
hoteltype1-1.zip
Sign in to reply to this post

georgina_barrett_187762

I have fixed it. I did need both repeat regions I just needed the repeat selection to be inside the repeat region. I had it the other way around before.

I have another question. I only want the record to be inserted if the user selects a particular day on a room type for example if the user selects a single room on Monday and Tuesday and a double room on Tuesday and Wednesday - I only want those 2 records to be inserted - I don't want the triple room and the quadruple room to be added (with blank values). I can get it to work by adding a checkbox with the room type as the value and then on the multiple insert it only inserts if the checkbox is ticked ($WA_insertIfNotBlank = "Occupancy";). The problem with this is that often the user is just selecting the days and not ticking the roomtype check box. Is there a way that I can say if (MonTotal OR TueTotal OR WedTotal OR ThurTotal OR FriTotal OR SatTotal OR SunTotal) is not empty
insert the record.

So instead of:
$WA_insertIfNotBlank = "Occupancy";

It would say something like:
$WA_insertIfNotBlank = "(MonTotal || TueTotal || WedTotal ||ThurTotal || FriTotal || SatTotal || SunTotal)";

Sign in to reply to this post

Jason ByrnesWebAssist

no, there is not a way to insert the record if if any of the days are ticked, they must select the occupancy as well.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...