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

What is the matter ???

Thread began 5/23/2012 2:38 pm by Peterson Design Studio - jefferis | Last modified 5/25/2012 5:52 pm by Jason Byrnes | 2483 views | 36 replies |

Peterson Design Studio - jefferis

What is the matter ???

Okay, guys, I am having an impossible time with this program. Either it is a lack of clear tutorial directions or something is just not working as it should

I am trying to create 2 things: a secure zone for dealers to login and register, and a data search for their orders.

When I use the wizards for example, the pages are producing blank white pages whether or not I have security attached to them.
When creating search for orders, It is creating only the search criteria form, but NO results pages. I realize I am using a template page with a DB connection as a base, but nothing seems to produce the results pages. Using a single Search page is not working either.

I am completely frustrated by this set of programs and not sure why things are not working as they did years ago where automation is / was pretty simple. I NOTE that I am trying to use existing tables in the DB to search not using the Orders table created by WA, but that shouldn't be a problem. My orders are not in the orders table!

DealerOrders.php

Sign in to reply to this post

Peterson Design Studio - jefferis

Syntax error

<?php
$Paramkey_WADArequests = "-1";
if (isset($_GET['key'])) {
$Paramkey_WADArequests = $_GET['key'];
Doing a search set of pages from scratch with blank pages, I am getting 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 'key, Jewelry_Type, Setting_Style, Head_Type FROM requests WHERE Dealer_ID LIKE '' at line 1


This is the request//

mysql_select_db($database_Ben, $Ben);
$query_WADArequests = sprintf("SELECT key, Jewelry_Type, Setting_Style, Head_Type, Prong_Style, Gallery, Shank_Metal, Shank_KaratsW, Shank_KaratsY, Shank_Style, Inside_Shank, Shank_Height, Shank_Width, Edge_Finish, Finger_Size_Main, Finger_Size_half, Gender, Main_Diamond_Shape, MD_Carat, MD_MM_Size, Crown_HeightMM, MD_Color, MD_Clarity, Shoulder_DIamonds1_Shape, SD1_Quantity, SD1_Carat, SD1_MM_Size, SD1_Color, SD1_Clarity, Shoulder_Diamonds2_Shape, SD2_Quantity, SD2_Carat, SD2_MM_Size, SD2_Color, SD2_Clarity, Other_Diamonds_Shape, OD_Quantity, OD_Carat, OD_MM_Size, OD_Color, OD_Clarity, First_Name, Last_Name, Email, Comment, Phone, Call_Time, Address, City, State, Country, Zip FROM requests WHERE key = %s", GetSQLValueString($Paramkey_WADArequests, "int"));
$WADArequests = mysql_query($query_WADArequests, $Bendannie) or die(mysql_error());
$row_WADArequests = mysql_fetch_assoc($WADArequests);
$totalRows_WADArequests = mysql_num_rows($WADArequests);
?>

Sign in to reply to this post

Ian S

It looks like you are using a reserved word as a field name.

I'm pretty sure that 'Key' is a reserved mySQL word that can't be used as a field name.

Cheers
Ian

Sign in to reply to this post

Peterson Design Studio - jefferis

thanks Ian

yes that was the problem... the "key" field was created automatically by my database. Very dumb.


Still can't get security features to work properly... and I'm not sure the update feature is working properly because the order number does not show when the form loads. And when you press update, it produces a blank page: requests_update.php...

Sign in to reply to this post

Ian S

White pages can mean there is a PHP error occurring on the page or you have whitespace in-between PHP tags.

If you add

<?php
ini_set('error_reporting', E_ALL);
?>



to the top of one of your pages it should tell you where the problem lies. If you still don't get an error then remove any spaces after closing PHP tags, or carriage returns between PHP tags if they exist.

Cheers
Ian

Sign in to reply to this post

Peterson Design Studio - jefferis

Originally Said By: Ian S
  
<?php
ini_set('error_reporting', E_ALL);
?>
  



Hi, I had checked for whitespace errors but did not find any. Checked in BBEdit, no CRs either. I tried the error code and still got a white page and not results.

Sign in to reply to this post

Ian S

I'd probably need to see a copy of your code to troubleshoot further, if its not displaying an errors.

Can you zip it up and attach it to your next post?

Cheers
Ian

Sign in to reply to this post

Peterson Design Studio - jefferis

Okay, here it is. Thanks.

Attached Files
DealerOrders.php.zip
Sign in to reply to this post

Ian S

Thanks.

I am a bit confused by the code to be honest.

There are two record sets on the page with identical names, so there is a conflict straight away.

The first one seems to be working with a Tom Muck extension to create a dynamic search.

In the second copy of the recordset you are referencing a Web Assist DA Search instance, but you don't have the Web Assist DA Search code on the page? Nor do you have the necessary includes for the Web Assist DA Search.

Cheers
Ian

Sign in to reply to this post

Peterson Design Studio - jefferis

Oh, The search code for WA was not working so I pulled it. Here is a revised page. No search on it, except an inactive form. I have security on it now. The linked files are uploaded, but it it is only producing a white page instead of redirecting to the login page.

What got me started is the security issue, but I'm also finding problems with the search pages not redirecting or finding detail pages... I keep starting over from scratch to get a clean set of pages, but nothing is working right.

Attached Files
DealerOrders.php.zip
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...