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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

I'd like to create a temporary table using the mysqli server behaviors but I'm not exactly sure how to accomplish it.

Thread began 2/28/2017 8:19 pm by Fred | Last modified 3/01/2017 12:26 am by Ray Borduin | 35 views | 3 replies |

Fred

I'd like to create a temporary table using the mysqli server behaviors but I'm not exactly sure how to accomplish it.

What I have so far is :

$createtemptable = new WA_MySQLi_Query("createtemptable",$RPi,0);
$createtemptable->setQuery("create temporary table currentIDs select distinct(project_id) from oldcredits union select distinct(ID) from projects");
$createtemptable->execute();

but I am getting a " PHP Fatal error: Call to a member function Prepare() on string in /research/webassist/mysqli/queryobj.php on line 123"

Any Suggestions? Is there a way to do this in the advanced query interface?

Thanks

Sign in to reply to this post

Ray BorduinWebAssist

It should just be:

php:
<?php

$createtemptable 
= new WA_MySQLi_Query($RPi);
$createtemptable->setQuery("create temporary table currentIDs select distinct(project_id) from oldcredits union select distinct(ID) from projects");
$createtemptable->execute(); 
?>
Sign in to reply to this post

Fred

Thanks. Sorry about that, still learning the ropes in my conversion process. This is not something that the Server Behaviors framework would have coded for me I assume. I didn't see where/how I could have used the server behaviors framework interface to create this code for me. Or did I miss something?

Sign in to reply to this post

Ray BorduinWebAssist

No you need to hand code that one. The library has functionality that isn't covered in the interfaces.

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