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

Long Description not showing on Details page.

Thread began 9/03/2012 12:14 pm by willo009412397 | Last modified 9/04/2012 2:36 pm by Jason Byrnes | 558 views | 3 replies |

willo009412397

Long Description not showing on Details page.

Hi
I have 2 problems i hope its ok to place them both here together, as there Dataassist related.
On my Details Page the Long Description is not showing?
And on my Update page everything updates but not the Image. Thanks for your help.

Regards Karl

Attached Files
DetailsPage.zip
Sign in to reply to this post

Jason ByrnesWebAssist

I dont see why the long description would not show on the details page unless the column is empty in the database, the code to show it is on the page.

double check that the long description column is being populated in the data base.

to troubleshoot the issue with the image upload, I'll need to make a few changes to the update page to gather some information

1) add the following code at line 1:

php:
<?php

error_reporting
(E_ALL);
ini_set('display_errors','on');
?>



2) change the redirect URL:

php:
$WA_redirectURL = "Adminproducts_Results.php";




to:

php:
//$WA_redirectURL = "Adminproducts_Results.php";

$WA_redirectURL = "";



3) add the following code just before the </html> tag, this will show the update SQL:

php:
<?php echo("SQL: ".$WA_Sql.""); ?>



4) On the bindings panel, expand the WA UPloaded FDiles global Status group and add the Debug info binding to the page.

send the results after testing a new update with an upload.

Sign in to reply to this post

willo009412397

Hi Jason

Thankyou for your help, i have added the code but i dunno if i have done it right? When i open the page i have this code shown below, it pushes my header down the page and has this:


Notice: Undefined variable: WA_Sql in C:\xampp\htdocs\PrintingColourUK.Com\Templates\Adminproducts_Update.php on line 120
SQL: Status object: WA_UploadResult1
statusCode : -1
errorMessage :
clientFileName :
fileExtension :
serverFileName :
serverSimpleFileName :
serverDirectory :
contentType :
fileWasOverwritten :
fileWasSkipped :
fileWasRenamed :
fileSize : -1
isImage :
imageWidth : -1
imageHeight : -1
WA_UploadResult1_1:
clientFileName :
fileExtension :
serverFileName :
serverSimpleFileName :
serverDirectory :
contentType :
fileSize : -1
imageWidth : -1
imageHeight : -1

Then if i try an Image Uplaod i get this:

SQL: UPDATE `products` SET `ProductName` = 'A5 Flyer (148 x 210mm)', `ProductPrice` = 24.99, `ProductShortDesc` = 'Our high quality promotional flyers are printed in full colour (CMYK) including Digital Photograph. Printed Full Colour on 135gsm Gloss Art Paper.', `ProductLongDesc` = 'Our high quality promotional flyers are printed in full colour (CMYK) including Digital Photograph. Printed Full Colour on 135gsm Gloss Art Paper.', `ProductImage` = 'A4_Flyer.jpg' WHERE `ProductID`=1Status object: WA_UploadResult1
statusCode : 1
errorMessage :
clientFileName : A4_Flyer.jpg
fileExtension : jpg
serverFileName : A4_Flyer.jpg
serverSimpleFileName : A4_Flyer
serverDirectory : C:\xampp\htdocs\PrintingColourUK.Com\Templates\..\Shop\ShopImages\
contentType : image/jpeg
fileWasOverwritten : 1
fileWasSkipped :
fileWasRenamed :
fileSize : 9723
isImage : 1
imageWidth : 180
imageHeight : 230
WA_UploadResult1_1:
clientFileName : A4_Flyer.jpg
fileExtension : jpg
serverFileName : A4_Flyer.jpg
serverSimpleFileName : A4_Flyer
serverDirectory : C:\xampp\htdocs\PrintingColourUK.Com\Templates\..\Shop\ShopImages\
contentType : image/jpeg
fileSize : 9723
imageWidth : 180
imageHeight : 230
isImage : 1
fileWasOverwritten : 1
fileWasSkipped :
fileWasRenamed :
statusCode : 1

I have attached copy of Upload.php for you in-case i have added the code wrong.

Regards Karl

Attached Files
Results_Page.zip
Sign in to reply to this post

Jason ByrnesWebAssist

according to this:

SQL: UPDATE `products` SET `ProductName` = 'A5 Flyer (148 x 210mm)', `ProductPrice` = 24.99, `ProductShortDesc` = 'Our high quality promotional flyers are printed in full colour (CMYK) including Digital Photograph. Printed Full Colour on 135gsm Gloss Art Paper.', `ProductLongDesc` = 'Our high quality promotional flyers are printed in full colour (CMYK) including Digital Photograph. Printed Full Colour on 135gsm Gloss Art Paper.', `ProductImage` = 'A4_Flyer.jpg' WHERE `ProductID`=1


the image name is being added to the updated record correctly:
`ProductImage` = 'A4_Flyer.jpg'

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