close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Deleting records database

Thread began 7/29/2014 4:21 pm by gail.bergan407744 | Last modified 7/31/2014 11:28 am by Jason Byrnes | 817 views | 6 replies |

gail.bergan407744

Deleting records database

I'm building a page for our admins to delete member records from our database. I used your Delete Record server behavior, but I'm getting an error message on lines 49-50 on the attached file. Can you spot what is wrong?

Sign in to reply to this post

Jason ByrnesWebAssist

  but I'm getting an error message on lines 49-50 on the attached file. Can you spot what is wrong?  



what is the full text of the error message?

To troubleshoot an error, i need to know what the error says. . .

Sign in to reply to this post

Jason ByrnesWebAssist

this code:

if (isset(".(isset($_GET['user_id'])?$_GET['user_id']:"")  .")) {
$colname_getUser_i = ".(isset($_GET['user_id'])?$_GET['user_id']:"") .";
}



should be:

if (isset($_GET['user_id'])) {
$colname_getUser_i = $_GET['user_id'];
}
Sign in to reply to this post

gail.bergan407744

Erroneous code

I'm glad you received the file, I was beginning to think I forgot to attach it.

That incorrect bit of code is not something I manually entered - how do I check for this in the future? I'm not knowledgeable enough to hand-code things or spot errors.

Sign in to reply to this post

Jason ByrnesWebAssist

when you created the recordset, you entered the run time value for the filter variable incorrectly, that caused the code to be generated incorrectly.

Sign in to reply to this post

gail.bergan407744

I'm not even sure where to set a run time value for a filter variable - where do I do that? Now, even with the new code you sent, I'm getting a different error message. Please see attached file. The message is:

Warning: mysql_select_db() expects parameter 2 to be resource, object given in C:\wamp\www\2010 new site\delete_user2.php on line 53

Warning: mysql_query() expects parameter 2 to be resource, object given in C:\wamp\www\2010 new site\delete_user2.php on line 55

Sign in to reply to this post

Jason ByrnesWebAssist

you would set the run time value for the filter in the filter section of the recordset.

the recordset that you are using on this page is a standard MySQL recordset, not one from the MySQLi server behaviors, but you have selected to use the MySQLi connection.

you need to create a standard connection to use with the standard recordset or remove the recordset and recreate it as a MySQLi recordset.

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