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

Select a Record based on Cart Column Value

Thread began 3/06/2014 12:56 pm by Mike Perry | Last modified 3/06/2014 4:22 pm by Jason Byrnes | 329 views | 12 replies |

Mike Perry

Select a Record based on Cart Column Value

I have a PlayerID stored as a column in the cart. If I include the Player recordest in the cart display page how do I use the PlayerID from the repeating Cart region to call and display a Player Name in the cart display?

Thanks,

Mike

Sign in to reply to this post

Jason ByrnesWebAssist

in advanced view, set the where clause as:

WHERE PlayerID = paramPlayerID


create a new variable as:
name: paramPlayerID
type: integer
default value: -1
runtime value: $cartName->DisplayInfo['PlayerID']


NOTE: for this to work, the recordset needs to be inside the cart display loop. If you need further help with the configuration, we can help in a premiere support appoinment

Sign in to reply to this post

Mike Perry

So I need to create the RS an then move the code into the repeating region?? Then echo the $row_Recordset??

Sign in to reply to this post

Jason ByrnesWebAssist

yes, that is correct.

Sign in to reply to this post

Mike Perry

Not working. . .

Page attached:

If I display the PlayerID in the field (<?php echo $sherwin1->DisplayInfo("Name"); ?> it shows the proper PlayerID. If I display the Total rows from the Recordset it show 0 (<?php echo $totalRows_Players; ?>. If I display the parameter from the MYSQL for the RS it shows the default -1 (<?php echo $sherwin1->DisplayInfo("PlayerID"); ?>).

Seems that the RS code isn't picking up the PlayerID from the Cart, but it is there. . .

RS code starts at line 198. . .

Mike

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

Jason ByrnesWebAssist

you're welcome.

Sign in to reply to this post

Jason ByrnesWebAssist

I had incorrect syntax for the run time value.

the correct syntax for the run time value is:

$sherwin1->DisplayInfo("PlayerID")

Sign in to reply to this post

Mike Perry

That creates an internal server error -- page doesn't load. . .

Sign in to reply to this post

Jason ByrnesWebAssist

I'll need to troubleshoot directly, see the private message section.

Sign in to reply to this post

Mike Perry

See Below. . .

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