Jump to content
  • 0

relational pages/passing parameters


dedwards0956

Question

I have been working on getting a relational page set up. Cannot get parameter passing to work.

I have a vendors table and a details table. One to many relationship.

I have set up a search/report page which displays my vendors with an HTML link to details.

Details

I am using my personal Verizon account for testing this before I go to the bother of setting up a page on our business website. (Work site is a lot of bother and not flexible to play with)

My first datapage displays fine and my details links have this html when clicked....

http://mysite.verizon.net/vzeqswxa/vendors/id3.html?&VendorNam=APPLE COMPUTER INC&cbResetParam=1

Vendor name seems to be there correctly but I end up with a 404 error

Could this be a Verizon problem....possibly the site not allowing the java script? Although the Vendor page with javescript seems to work fine.

Any help greatly appreciated.

dan

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi Dan,

What is the design tool you use to create your web pages? Basically the site builder that you are using is not allowing to pass parameters in the URL.

As you see when you delete the ? and the rest, it works fine but if you add even only one parameter like ?id=1 you will see it sends you to a page not found. You need to ask the site builder tool support how you can set the URL accept parameters.

Hope this helps.

Best,

Bahar M.

Link to comment
Share on other sites

  • 0

Hi, Novice Caspio user here (and novice at web design), wondering if anyone can help me

 

I have successfully imported two Access data tables into Caspio and have built simple Search & Select pages that display fine on my web site.

However I really need my details page to be relational and show data from both tables. The one to many links work fine in access and the field names match etc.

 

I've followed the guidance, enabled the parameters and built a search page plus separate "details" pages to display data from both tables - one is a details page report and the other a tabular report. I have added an html box in the search page showing where the results should be displayed.

 

However I cannot get the data to display on the web site. It simply produces a box that says "no records found".

 

My understanding is that

1) I deploy the search page into Page A of my web site

2) The added html code in that search page sends the results (ie the details pages) to be displayed on Page B of my site

Correct me if the above is wrong

 

My questions are:

a) Am I supposed to deploy the "details" pagess to Page B of my site? or do I just leave Page B blank (I have tried this both ways but still don't get anything displayed - I just want to know what is the right way)

B) How does the search page know which "detail" pages to call?  Sorry if that sounds like a daft question. In the "details" report there is an option to link the page to the search form. Am I supposed to tick this? If so what do I put in the search url? - the caspio address or my web site's address

c) If the answer to b is affirmative, how would I do this on the tabular report which doesn't have these options?

 

Thanks in anticipation, Simon

 

 

 

 

 

 

 

 

Someone else raised

Link to comment
Share on other sites

  • 0

I think I answered my own questions. Just in case anyone ever posts similar question...

1 & 2 ) Correct assumptions

a) Yes

B) No

c) N/A

 

in the end I found there was a typo in my html block - embarrassing. Corrected it and hey presto the code worked and the pages appeared.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...