close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Recordsets not displaying

Thread began 11/28/2021 12:16 pm by john70964 | Last modified 12/03/2021 9:04 am by Ray Borduin | 163 views | 7 replies |

john70964

Recordsets not displaying

Hi Ray,
I have problems with some files.
Recordsets are not being shown in bindings or server behaviours.
Also 2 files do not seem to function in localhost.

The two files Canal.php and Catamaran.php are working on the remote server so I down loaded these files to replace the two non working files.

Both show these errors
Warning: require_once(Connections/conn1_i): failed to open stream: No such file or directory in C:\xampp\htdocs\bfsnmysql57\canal-boats.php on line 1

Fatal error: require_once(): Failed opening required 'Connections/conn1_i' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\bfsnmysql57\canal-boats.php on line 1
I am attaching the files.

Has a method been found to get absent Recordsets showing again?

I am attaching the files in the hope they help.
Many thanks for any help
John

Sign in to reply to this post

Ray BorduinWebAssist

It looks like your connections file is named "conn1_i" instead of "conn1_i.php".

If you rename the file that may correct both issues. Usually if a server behavior isn't showing properly I can close and re-open the page and they will show properly.

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

Originally Said By: Ray Borduin
  It looks like your connections file is named "conn1_i" instead of "conn1_i.php".

If you rename the file that may correct both issues. Usually if a server behavior isn't showing properly I can close and re-open the page and they will show properly.  


Thanks Ray,
Yes you are correct I did have have conn1_i and not conn1_i.php in the first line.
I corrected this and closed Dreamweaver but the recordset does not show when I reopen the page.

I am now getting this error
Warning: mysql_select_db() expects parameter 2 to be resource, object given in C:\xampp\htdocs\bfsnmysql57\boat-details.php on line 37

Warning: mysql_query() expects parameter 2 to be resource, object given in C:\xampp\htdocs\bfsnmysql57\boat-details.php on line 39

Please see attached file.
Many thanks
John

Sign in to reply to this post

Ray BorduinWebAssist

It looks like you have a mySQLi connection but some of your code is still mySQL. This page would need a mySQL connection to work properly.

It looks like you have repeated recordset code too.
Try this:
1) Delete lines 42-49 (repeated code)
2) Open the rsBoats recordset from the server behaviors window and re-apply it (that should update it to mySQLi)

If it still doesn't work, attach the updated file in a reply to this post and I'll take another look.

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

Thanks Ray,
In boat-details.php the recordset filter is set to CatBoats = url Parameter.
I test this with category10 hire boats which is correct.

I click OK but the Server Behaviour window shows a red marker.

I open the Recordset and URL parameter is changed to Entered value.
I have tried several times but with the same result.

Sign in to reply to this post

Ray BorduinWebAssist

It looks like it doesn't recognize that you are updating from mySQL to mySQLi and it is keeping the mySQL version of the code on the page. If you give me FTP access I can try to fix it for you.

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

Thanks Ray,
The remote server is having some problems at the moment, there is a notification to the effect some sites are not working.
I expect this is because we have an unusually large weather storm here a couple of days ago and many services are facing problems.

Re the site on the remote server, all pages are working OK, except that they are taking over a minute to open.

I will be in touch later.
Regards
John

Sign in to reply to this post

Ray BorduinWebAssist

I couldn't comment on Filezilla connection issues. It could be your server, your connection, or your credentials. I'd guess that reinstalling Filezilla won't fix the issue, but you could try.

Sign in to reply to this post
Did this help? Tips are appreciated...

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