Simple? View Single Record using URL?

Hi folks,

Im simply trying to view a single record in my database simply by using the address bar or URL, calling from a short list in a table.

For instance, why doesnt this show me a single page record?

index.php?option=com_chronoconnectivity&connectionname=SingleWebinar&cf_id=5

I want to show a single custom page that I make for each of my instructors' webinars.

do i have the URL totally messed up? I want to view cf_id=5 (dynamically from previous page)

What would the URL be?

Or for that matter, why wouldn't this work?
index.php?option=com_chronoconnectivity&connectionname=WebinarSubmissions&task=viewrecord&cids=4

Hi rblanda,

Are you trying to link from a ChronoConnectivity listing?

If so, have you checked this document?

Bob

Mr. Greyhead,

I have downloaded and read most of your document. What I find utterly stunning, is that Im already using ChronoConnectivity, and can display articles and everything is working great. However is there really no simple way to link to ONE single record in the database? I was just going to link with the CF_ID# from a previous page. We do not require much interactivity at all.

As I am a beginner "PHP/MySQL wannabe" the code in your book is extrememly confusing. Why all that just to display ONE record? Is there really NO WAY to link inside the URL? We may want to pass variables to the URL later on in life.

I can give you access to the website admin if you feel you need to look at my configuration, but I just find it interesting that its so much work just to link to a record. I find that it will be easier to simply build a simple PHP page that will display the record and link to it from the ChronoConnectivity area.

I do, however appreciate that you took much time to write the document you sent me - Im sure you're barraged with questions every day regarding this engine.

Perhaps Im just missing something simple.


Thanks for your time.

Rob

Hi Rob,

Maybe I don't understand what you are trying to do.

If you want to use a ChronoForm to display the values from a single database record then you can use the Profile Page plug-in.

Bob

I don't even need to create a form to display a page. I just need a simple link to a single record. Nothing more. It's already password protected and for internal references only.

That plugin also confused me - I enabled it, and there was nohting to do? there was little to no documentation on how to enable it - or to use it.

Let me tinker with that a little, maybe that will resolve my problems.

Thanks again for all your help - and yes, a cold beer - ON ME.

- Blanda

Hi Rob,

What is the page you want to display? Is it a Chronoform or some other PHP page?

I'm still missing something here :-(

Bob

Im sorry, and I really do appreciate your patience.

Ok, here goes:
I created a form for our "presenters" to fill out (chronoform) to populate the database with their course information. I then installed chronoconnectivity (cool plugin, by the way), and I return the results, no problem. Pages look good too. However, it's displaying all the records. I then created another connectivity page to return an "at-a-glance" list of the presentations available. I want to be able to simply link the presentation name with the single record of that particular presentation using a link. Thats pretty much it.

Thanks, GrayHead!

GrayHead, give me a few mins, and I'll post the screenshots for you.

Ok, these should shed some light. (they ARE in order)

http://gxpconferences.com/screenshots/001.jpg
http://gxpconferences.com/screenshots/002.jpg
http://gxpconferences.com/screenshots/003.jpg

Hi Rob,

In the ChronoConnectivity listing you can add a link to - for eaxmple - the name:

<a href='index.php?option=chronocontact&chronoformname=bio&cf_id={cf_id}'>{name}</a>

The in the Form HTML for the form you use the cf_id parameter to lookup the bio data for that record and display it.

Bob

Hello,
I'm trying to display a single record by URL, but this doesn't work for me:

http://www.kncb.nl/index.php?option=chronocontact&chronoformname=clubinfo&cf_id=4
(just gives me a new form or an empty page). What am I doing wrong this time 😀 ?

regards,
Birdy

Hi Birdy,

Are you using the Profile Page plug-in with this? It will either need that or code to load the data.

Bob

Aha, I thought that was a Joomla plugin, didn't know where to download it and I couldn't figure out what it was for actually... 🙂

But it's working, thanx again!
Birdy

Sorry about jacking this thread but been working on the "View Single Record" pdf tutorial. I'm been working on the first part where you type in the &id=1 on chronoform link but stuff does not display correctly. My tags like {introtext} just displays {introtext} in the front end instead of the value on what it is suppose to be. Profile plug-in is setup properly so not sure why it's displaying like this.

Never mind I didn't turn on the plugin.