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

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.

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

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.

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

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

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

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

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

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.