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 record inserts with session variable

Thread began 2/28/2012 3:23 pm by asarcona308398 | Last modified 7/17/2014 3:25 pm by Jason Byrnes | 1856 views | 9 replies |

asarcona308398

Multiple record inserts with session variable

I can't seem to get multiple record inserts to work, although i can get a single insert to work.
the database records single inserts using a session variable set and passed from previous inserts on the same page, but if i change the single insert to multiple inserts using the same repeat region, and session variable, it records nothing...
any help much appreciated

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

Jason ByrnesWebAssist

to help troubleshoot, trey changing line 526:

php:
$WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";




to:

php:
$WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";
echo($WA_Sql."||".$_SESSION['sg_instructor_instructor_id']."<br /");
Sign in to reply to this post

asarcona308398

multiple inserts

Jason,
the session variable doesn't show on the page, but it is in the session file, and has a correct value.
attaching new file with ammendment to line 526

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

Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Sign in to reply to this post

debbie295402

Multiple records insert doesn't insert and header warning error on submit

I think I have the same problem. I looked at the view source (below) and the session variables are not being inserted, or any other information showing. Warning on submit is: Warning: Cannot modify header information - headers already sent by (output started at /home/content/53/8580253/html/member_area/committeeSignup.php:59) in /home/content/53/8580253/html/member_area/committeeSignup.php on line 92. the page is within a member area so I have to paste code for you to view.

I've had a heck of a time with this and have had to undo a couple of times, close out dw, empty cache, then start over in order not to get errors when adding multiple insert. Please let me know if you need any additional information

code is sent by pm.

Sign in to reply to this post

Jason ByrnesWebAssist

Looks like there are blank lines between closing php tags:

?>

and opening php tags in the code:

<?php


that will cause the headers already sent error.

For the trigger, you are using Current Page submit, try changing that to Button submit pressed, or any form post instead.

NOTE: in the future, please don't paste the page code to your message, instead attach a copy of the php page.

Sign in to reply to this post

debbie295402

Apologies for the text, but I've gotten used to support sites that don't take attachments. Noted for the future.

Removing the spaces worked to remove the error, however the information is still not posting to the database.

Additionally, within the member area I'm using the session variables to display personalized info but the session variables aren't displaying initially (Hello [sv] [sv]). If I go to the member update page, don't make any changes, then go to the signup form the session variables display correctly.

Also, apologies for the late reply. I responded to this over a week ago, but my system crashed before this posted. Been installing software for the last 3 days after a week out of commission.

update:
after trying to work through this I find that none of the session values for the logged in use are being displayed, eve if I go to the update page (which works fine). So I'm unable to grab the logged in user id or other session values and display them on the page and/or add them to the fields to be inserted. It is displaying the first field values of the database. New file attached.

Sign in to reply to this post

Jason ByrnesWebAssist

Please provide a Skype username or a US phone number and a good time to contact you when you will be in front of your computer and we will have an engineer contact you to resolve this issue over the phone.

We are available Monday - Friday from 9am - 4pm EST (except major U.S. holidays).

Sign in to reply to this post

debbie295402

dshsolutions
I can be available whenever you need. I'm online now. I'm in Cali PST

Sign in to reply to this post

Jason ByrnesWebAssist

we looked at this in a connect session, I pointed to the manage relational table tutorial for details on how to accomplish the end goal.

http://www.webassist.com/tutorials/Manage-relational-tables

Sign in to reply to this post
loading

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...