close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

In a recordset, default value in bindparam is ignored.

Thread began 8/08/2016 12:06 pm by anonymous | Last modified 8/10/2016 2:52 pm by Ray Borduin | 1321 views | 11 replies |

anonymous

In a recordset, default value in bindparam is ignored.

Example
$rsPR = new WA_MySQLi_RS("rsPR",$bizopp_i,1);
$rsPR->setQuery("SELECT * FROM prodview WHERE package = ?");
$rsPR->bindParam("i", "".(isset($_GET['package'])?$_GET['package']:"") ."", "6"); //colname
$rsPR->execute();
Gives no results if I load the the page without ?package=x query in url, while there are a lot of records in database with filed package = 6. It works with the query.

Thank you

Sign in to reply to this post

Ray BorduinWebAssist

Try updating that line to:

$rsPR->bindParam("i", "".(isset($_GET['package'])?$_GET['package']:"6") ."", "6"); //colname

If you give me FTP access I can look into the problem with it not using the default value and get it corrected directly, but this work around should make it use 6 if the url parameter isn't set for now.

Sign in to reply to this post

anonymous

re: In a recordset, default value in bindparam is ignored.

Thank you for your reply.
The workaround is working, I send you anyway ftp access in private message.

Sign in to reply to this post

Ray BorduinWebAssist

I can't seem to get in with the FTP information you have provided. Please test and make sure there are no typos and that it works for you.

Sign in to reply to this post

anonymous

Hello, did you choose "ACTIVE MODE" in connection settings? Which error do you get?

Sign in to reply to this post

Ray BorduinWebAssist

Yes. Does it work for you? I get an error retrieving directory listing.

Sign in to reply to this post

anonymous

Yes, iìm using Filezilla client. Please find connection settings in attachment.

Sign in to reply to this post

Ray BorduinWebAssist

I'm using the same exact settings with filezilla. Anything set on the other tabs?

Sign in to reply to this post

anonymous

Nothing else. I don't know why it does not work for you. I have planned a server restart in 6 hours (1.00 AM my time). Can you try again after that? Thanks

Sign in to reply to this post

Ray BorduinWebAssist

Here is the log:

Status: Connection established, waiting for welcome message...
Status: Logged in
Status: Retrieving directory listing...
Command: PWD
Response: 257 "/" is current directory.
Command: TYPE I
Response: 200 Type set to I
Command: PORT 192,168,0,55,219,81
Response: 200 Port command successful
Command: MLSD
Response: 150 Opening data channel for directory list.
Response: 425 Can't open data connection.

It says I'm logged in but can't get the directory listing for the root folder.

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