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

problems with DATAASSIST

Thread began 1/25/2011 6:59 pm by posta421349 | Last modified 2/01/2011 4:18 am by paolo410517 | 2646 views | 13 replies |

posta421349

problems with DATAASSIST

hi
I made a really simple data assist wizard
every page works correctly except the "insert record" page

I put some tex in the two fields (text area) the I click "insert an the browser displays:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' (an then some text that I intended to insert )

I read a thread in which you talk about avoiding spaces in the records name...

after many test it seems that what you've said about the "avoiding space" can be applied (in my case) not to the record labels but to the record fields!!!

php version is 5.3, adobe cs4, mac osx 10.6 snow leopard
please help

thanks in advance for your help

Marco

Sign in to reply to this post

Jason ByrnesWebAssist

please send a copy of your page so i can see the code.

Sign in to reply to this post

ArtimediuS

Here is the code

by the way I've also tried to uninstall extension (10 mins!!!!!!) and then reinstall, and then rebuilt pages, with same errors and problems... I've also encountered many problems with form builder, and as I can read there are many customers disappointed with many problems reports....
so please give me a real solution for all the problems I'm encountering, otherwise I will recall the money back guarantee.


here is the code of the insert page.

<?php require_once('Connections/connect_am.php'); ?>
<?php require_once("WA_DataAssist/WA_AppBuilder_PHP.php"); ?>
<?php
// WA Application Builder Insert
if (isset($_POST["Insert_x"])) // Trigger
{
$WA_connection = $connect_am;
$WA_table = "portfolio";
$WA_sessionName = "WADA_Insert_portfolio";
$WA_redirectURL = "portfolio_Detail.php";
if (function_exists("rel2abs")) $WA_redirectURL = $WA_redirectURL?rel2abs($WA_redirectURL,dirname(__FILE__)):"";
$WA_keepQueryString = false;
$WA_indexField = "ID";
$WA_fieldNamesStr = "tipologia|committente|oggetto|descrizione|foto|note";
$WA_fieldValuesStr = "".((isset($_POST["tipologia"]))?$_POST["tipologia"]:"") ."" . "|" . "".((isset($_POST["committente"]))?$_POST["committente"]:"") ."" . "|" . "".((isset($_POST["oggetto"]))?$_POST["oggetto"]:"") ."" . "|" . "".((isset($_POST["descrizione"]))?$_POST["descrizione"]:"") ."" . "|" . "".((isset($_POST["foto"]))?$_POST["foto"]:"") ."" . "|" . "".((isset($_POST["note"]))?$_POST["note"]:"") ."";
$WA_columnTypesStr = "undefined|undefined|undefined|undefined|undefined|undefined";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_connectionDB = $database_connect_am;
mysql_select_db($WA_connectionDB, $WA_connection);
if (!session_id()) session_start();
$insertParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
$_SESSION[$WA_sessionName] = mysql_insert_id();
if ($WA_redirectURL != "") {
if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
header("Location: ".$WA_redirectURL);
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/am_tmplt_cms.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Insert portfolio</title>
<!-- InstanceEndEditable -->
<style type="text/css" media="all">
<!--
@import url("CSSSculptor/AM2ColumnFixedLeftSidebarHeaderandFooter_AMORANGEWHITECMS_css/screen.css");
-->
</style>
<style type="text/css" media="print">
<!--
@import url("CSSSculptor/AM2ColumnFixedLeftSidebarHeaderandFooter_AMORANGEWHITECMS_css/print.css");
-->
</style>
<!--[if IE 5]>
<style type="text/css">
/* IE 5 does not use the standard box model, so the column widths are overidden to render the page correctly. */
#outerWrapper #contentWrapper #leftColumn1 {
width: 220px;
}
</style>
<![endif]-->
<!--[if IE]>
<style type="text/css">
/* The proprietary zoom property gives IE the hasLayout property which addresses several bugs. */
#outerWrapper #contentWrapper, #outerWrapper #contentWrapper #content {
zoom: 1;
}
</style>
<![endif]-->
<!--[if lt IE 7]>
<style type="text/css">
img, div {
behavior: url("../CSSSculptor/AM2ColumnFixedLeftSidebarHeaderandFooter_AMORANGEWHITECMS_images/iepngfix.htc");
}
</style>
<![endif]-->
<!-- InstanceBeginEditable name="head" -->
<link href="WA_DataAssist/styles/Refined_Pacifica.css" rel="stylesheet" type="text/css" />
<link href="WA_DataAssist/styles/Geneva.css" rel="stylesheet" type="text/css" />
<!-- InstanceEndEditable -->
</head>

<body>

<div id="outerWrapper">
<div id="header"></div>
<div id="contentWrapper">
<div id="leftColumn1">
<h2>GESTIONE</h2>
<h2>CONTENUTI DEL SITO </h2>
<p>MENU<a href="#"></a></p>
<hr />
<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Praesent aliquam, justo convallis luctus rutrum, erat nulla fermentum diam, at nonummy quam ante ac quam. Maecenas urna purus, fermentum id, molestie in, commodo porttitor, felis. Nam blandit quam ut lacus. Quisque ornare risus quis ligula. Phasellus tristique purus a augue condimentum adipiscing. Aenean sagittis. Etiam leo pede, rhoncus venenatis, tristique in, vulputate at, odio. <a href="#">More...</a></p></div>
<div id="content">
<h1>trattamento dati</h1>
<hr />
<!-- InstanceBeginEditable name="contenuto" -->
<p>&nbsp;</p>

<div class="WADAInsertContainer">
<form action="portfolio_Insert.php" method="post" name="WADAInsertForm" id="WADAInsertForm">
<div class="WADAHeader">Insert Record</div>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<table class="WADADataTable" cellpadding="0" cellspacing="0" border="0">
<tr>
<th class="WADADataTableHeader">tipologia:</th>
<td class="WADADataTableCell"><input type="radio" name="tipologia" id="tipologia" value="" />
[ Label ]<br />
<input type="radio" name="tipologia" id="tipologia" value="" />
[ Label ]</td>
</tr>
<tr>
<th class="WADADataTableHeader">committente:</th>
<td class="WADADataTableCell"><input type="text" name="committente" id="committente" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">oggetto:</th>
<td class="WADADataTableCell"><input type="text" name="oggetto" id="oggetto" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">descrizione:</th>
<td class="WADADataTableCell"><textarea name="descrizione" id="descrizione" cols="32"></textarea></td>
</tr>
<tr>
<th class="WADADataTableHeader">foto:</th>
<td class="WADADataTableCell"><input type="text" name="foto" id="foto" value="" size="32" /></td>
</tr>
<tr>
<th class="WADADataTableHeader">note:</th>
<td class="WADADataTableCell"><input type="text" name="note" id="note" value="" size="32" /></td>
</tr>
</table>
<div class="WADAHorizLine"><img src="WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<div class="WADAButtonRow">
<table class="WADADataNavButtons" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="WADADataNavButtonCell" nowrap="nowrap"><input type="image" name="Insert" id="Insert" value="Insert" alt="Insert" src="WA_DataAssist/images/Pacifica/Refined_insert.gif" /></td>
<td class="WADADataNavButtonCell" nowrap="nowrap"><a href="portfolio_Results.php" title="Cancel"><img border="0" name="Cancel" id="Cancel" alt="Cancel" src="WA_DataAssist/images/Pacifica/Refined_cancel.gif" /></a></td>
</tr>
</table>
<input name="WADAInsertRecordID" type="hidden" id="WADAInsertRecordID" value="" />
</div>
</form>
</div>
<!-- InstanceEndEditable --></div>
</div>
<div id="footer">
log out </div>
</div>

</body>
<!-- InstanceEnd --></html>

Sign in to reply to this post

paolo410517

DataAssist2 - not work

I confirm that I have the same problems, which are identical to the previous case. This is why I opened a ticket for a long time,


Opening date ticket: Date Submitted: 17/11/2010 11:43 am
This is the content of the ticket number 121538 *** THE CASE NOT RESOLVED***

############################
Dear support,
I did all the tests with the following condition:
- WorkStation Windows OS 7 to 64 bits
- Dreamweaver CS5 - Date Assist2 ver WADataAssist208.mxp
- Linux servers with Plesk Panel 9.5.4 last update
- link to see the evidence WebAssist: test_webassist/

enter login = paolo
password = pippo123

I did these tests follow all your step by step tutorial (dataassist_gsg.pdf, I used your text file to create the MySQL DB)

But when I do the update of a record I get this error:

You Have an error in your SQL syntax; check the manual That corresponds to your MySQL server version for the right syntax to use near 'Doubleundefined, `=` ItemShortDesc undefinedThe latest from Jenna Darleenundefin' at line 1

I am attaching the zip file containing all the PHP files produced by WebAssist2 automatically.

I ask you please to see where the problem is. Thanks.

, are still awaiting a solution.


IF YOU DO NOT SOLVE THE CASE FINALLY GIVING A SAFE AND ANSWER SOME OF THE PROBLEM, I ASK FOR A REFUND OF ECONOMIC price, otherwise I will go to appropriate law enforcement.

Sign in to reply to this post

biz295654

QUOTE}IF YOU DO NOT SOLVE THE CASE FINALLY GIVING A SAFE AND ANSWER SOME OF THE PROBLEM, I ASK FOR A REFUND OF ECONOMIC price, otherwise I will go to appropriate law enforcement.[/QUOTE]

Really? Unbelievable... These guys are great at support. Chill out.

Sign in to reply to this post

paolo410517

Let's see then! The solution.

I look .........

In addition, the dateTime are all wrong today is 01/28/2011 - 09:43 +1:00 (Date Roma)


################################


Allora Vediamo! La soluzione.

Attendo .........

Inoltre le dateTime sono tutte errate oggi è il 2011-01-28 - 09:43 +1:00 (Date Roma)

Sign in to reply to this post

ArtimediuS

Still waiting the solution

get this code....


STILL WAITING THE SOLUTION(s)


marco

Sign in to reply to this post

paolo410517

Ciao Marco possiamo scriverci direttamente?

la mia mail di rif è : paolo@c3p.it

da li scambieremo i nostri riferimenti.

Sign in to reply to this post

Jason ByrnesWebAssist

to help us troubleshoot the issue, find the following line:

php:
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());



and change it to:

php:
die($WA_Sql);

$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());




this will write the insert SQL statement to the screen to help us see what the issue is.



paolo410517:
We do not have a solution for why the data type to some of the columns is being set to Undefined. We asrew looking into the issue to find a solution, but it is a little dificult since we cannot reproduce it in any OS / Dreamweaver version combo.


the work around to the issue is to Edit the server behaviors and select the correct data type for each column.

We are still investigating the issue and hope to have it corrected in the next update.

Sign in to reply to this post

paolo410517

Posted By: paolo Message 12 in Log
Date: 01/30/2011 03:29 am No Attachments
Title: RE: Data Assist2 Not Work - windows 7 italy italiano

I confirm that I have done more testing with these features:

OS: Windows 7 to 64 prof.
Dreamweaver CS5 - English
DataAssist2 ver 2.0.8

So the update and Insert Record WORK! Visit the link :

countries_Results.php

Userid= paolo
Password= pippo123

The license I used, in this test, is ADOBE Treal, lasts 30 days. Instead, the license installed on my workstation, which is purchased is only Italian.

How will you solve the language problem in Dreamweaver? Consider that I specified when you purchase your license SuperSuite $ 499 !!!!!! I had a license Dreamweaver Italian?


How to solve this problem?

Expect a solution.

because if you sell your solutions do not work for dreamweaver in Italian?
Moreover, it provides a Treal for testing before purchase, so for these very reasons you have to solve the problem, I repeat, otherwise I call on the guarantee.






####################




Attenzione questo messaggio è per Ray.

Ray ti confermo che ho fato altre prove con queste caratteristiche:

sistema operativo : Windows 7 - 64 prof.
Dreamweaver : CS5 - Inglese
DataAssist2 ver 2.0.8

Così L'update del Record e l'Insert del Record FUNZIONANO!

La licenza ADOBE che ho utilizzato è treal, dura 30 giorni. Invece la licenza installata sulla mia workstation, è quella che acquistato è solo Italiano.

Come intendete risolvere il problema della lingua di Dreamweaver? Considera che ho specificato al momento dell'acquisto della vostra licenza SuperSuite 499$ !!!!!! avevo una licenza di Dreamweaver Italiano?

Come risolviamo questo problema?

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