Display Information from 3 Tables

Hello All;

Now, I am trying to get the [Search Results] Page to Display And right now,
it is simply giving me a Blank Page, but no Errors.

See, I am retreiving information from 3-Tables.
Cats - Contains information about the Categories
Sierra - Datafeed #1 Content
BrushStrokes - Datafeed #2 Content
(The Datafeeds cannot share the same Table, they hold 2 different sets of
information.
And now I am trying to show the information.

Below is the complete code from the [Display.asp] page.
I have the area's 'Commented To show where each area Starts.
Hope that someone can assist on this one.
This is totally new grounds for me, and after search Google, I found
information on simple display
But nothing this complexe.

(If I have not explained something clear enough, please let me know, and I
will do my best to help
You to understand what is going on here)

Thank You
Carrzkiss

==============Diaplay.asp=============
<%

if results = true then

%>

Re: Display Information from 3 Tables

To add to this.
The Search Query is working:

'Sierra.Display=1 AND BrushStrokes.Display=1 AND (Sierra.ContentId LIKE
'%pants%' OR Sierra.Product_Title LIKE '%pants%' OR
Sierra.Product_Description LIKE '%pants%'OR BrushStrokes.BSContentID LIKE
'%pants%' OR BrushStrokes.BSProduct_Name LIKE '%pants%' '.

Were you see the '%pants%' [Code] '%" & keywords & "%'
So when you type in something, it is getting the information that is typed
in, it is just not Sending the information
Back to the page.

Re: Display Information from 3 Tables

Wayne & Carr wrote:
> Hello All;
>
> Now, I am trying to get the [Search Results] Page to Display And
> right now, it is simply giving me a Blank Page, but no Errors.
>
> See, I am retreiving information from 3-Tables.
> Cats - Contains information about the Categories
> Sierra - Datafeed #1 Content

What is a "Datafeed"? Is it really relevant to this problem? if not, just
say so and don't bother explaining.

Oh wait:...you don't have a field with that name do you?

> BrushStrokes - Datafeed #2 Content
> (The Datafeeds cannot share the same Table, they hold 2 different
> sets of information.
> And now I am trying to show the information.

It is more helpful to show us actual field names along with their datatypes.
Show us the minimum number of fields needed to explain your problem.

>
> Below is the complete code from the [Display.asp] page.
> I have the area's 'Commented To show where each area Starts.
> Hope that someone can assist on this one.
> This is totally new grounds for me, and after search Google, I found
> information on simple display
> But nothing this complexe.
>
> (If I have not explained something clear enough, please let me know,
> and I will do my best to help
> You to understand what is going on here)
>
Jeez. Sorry, but I'm not going to plow through all that. I've got my own job
that my boss expects me to do.
You need to break down the problem. My advice: Start small. Do it in steps.
When you get to a specific step that you are having a problem with, get back
to us. While some of us may be willing to "plow through" a huge post such as
this, you are more likely to get assistance by being specific.
Also, this is an ASP group, which deals with server-side code. if you find
yourself posting a large amount of HTML, you should pause and consider
whether this is the appropriate group for your question. If you have HTML or
CSS questions, more appropriate groups would be:

http://groups.google.com/groups/dir?sel=33584039

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Display Information from 3 Tables

Hello "Bob Barrows";

Sorry for taking up your time. Did not mean to reach out and make you read
this post.
It is ASP related, not HTML (or) CSS related.

The lengthyness of the code, when I posted it, I was half a sleep.
And realized that I posted too much of it to be relavent to the issue.
(Like we have all done once before)

But, no problem.
As mentioned above, Did not mean to reach out and make you read it.

I will deal with it myself.

Re: Display Information from 3 Tables

Wayne & Carr wrote:
> Hello "Bob Barrows";
>
> Sorry for taking up your time. Did not mean to reach out and make you
> read this post.

>
Oh, you needn't feel sorry: you didn't take up my time. You see, I didn't
read your entire post. So no harm done.

And apparently, judging by the number of replies it received, neither did
anyone else read it.

So maybe, instead of getting sarcastic and defensive, you might want to
reread my reply and accept it in the spirit in which it was offered: helpful
advice about getting help in newsgroups.

If I hadn't replied, you might have been left wondering if the post made it
to the newsgroup, causing you to waste your time by reposting it.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Display Information from 3 Tables

Hell "Bob Barrows [MVP]";

I was not trying to be "sarcastic & defensive"
I was replying back to your:
[Quote]
Jeez. Sorry, but I'm not going to plow through all that. I've got my own job
that my boss expects me to do.
[/Quote]
This was uncalled for, so I was replying to this type of remark.
-----------

I did read what you wrote, and if you read what I replied to:
[My Quote]
The lengthyness of the code, when I posted it, I was half a sleep.
And realized that I posted too much of it to be relavent to the issue.
(Like we have all done once before)
[/End My Quote]

So, there is room for all of us to improve on our communications skills
right?

I have another person that is assisting me with the issue right now, that is
familuar
With the layout of the site, so hoepfully this issue will be resolved soon.

And if you took offense to what I said in this (or) the last post, then
Sorry.
Did not mean to offend. I was just replying with the same attitude as I was
given.

And as for the Newsgroups.
I have been giving help on them for as long as I have been receiving help.
Since the later part of 1999.
I have seen my share of Sarcasm come and go.
And I have seen it given back 2-fold.

Take Care Bob.
(Like the last name, mine is : Barron
The story behind the "Barron" name is that somewhere along the line,
A Dr. misspelled the last name on a Birth Certificate and instead of making
it:
Barron, it was spelled with a "w" instead of a "n" Which produced "Barrow"
(Information from our Family Tree that my Grand Father was working on before
he died
Jan, 1st 2004)

Wayne

Re: Display Information from 3 Tables

"Wayne & Carr" wrote in message
news:Okx$vcziGHA.1320@TK2MSFTNGP04.phx.gbl...

> Now, I am trying to get the [Search Results] Page to Display And right
now,
> it is simply giving me a Blank Page, but no Errors.

The reason for this is usually

1. There is an error but you need to right click in the browser and 'view
source' to see it
(any error will be at the bottom of the page)

2. There is nothing to show because...

> if results = true then

Maybe 'results' is actually not equal to true, try putting

response.write "results=" & results

above that line.

> do while not rs.EOF AND (rec_count < rs.Pagesize)

Either rs.eof is false, or rec_count >= rs.pagesize, or any of these is
null, try putting

response.write "do=" & (not rs.EOF AND (rec_count < rs.Pagesize))

above that line.

--
roger

Re: Display Information from 3 Tables

Hello Roger;


> > if results = true then
>
> Maybe 'results' is actually not equal to true, try putting
>
> response.write "results=" & results
>
> above that line.

I get this written on the page: results=False


> response.write "do=" & (not rs.EOF AND (rec_count < rs.Pagesize))
>
> above that line.

Cannot do this one yet, as it is not getting past the other
<%
if results = true then
%>


And, there is no Error on IE itself either.
I would love for there to be something, but there is not.

Re: Display Information from 3 Tables

Wayne & Carr wrote:
> Hello Roger;
>
>
> > > if results = true then
> >
> > Maybe 'results' is actually not equal to true, try putting
> >
> > response.write "results=" & results
> >
> > above that line.
>
> I get this written on the page: results=False
>
>

So you need to do as Bob suggested and break this down into manageable
chunks. Test each chunk as you go. Results=true is the condition
under which the entire code sample you posted runs, but you omitted to
post how 'results' acquires its value (or, at least, I can't see it)

Building on Bob's advice, this kind of task is best achieved without
the html at first. That just clutters your working space, and is
easily plugged in afterwards. It also eliminates possible html display
problems as a cause. Also, make sure the logic is working as you
intend by response.writing the value of your variables at important
points. Don't assume anything about their values. Always confirm
them.

If you get rid of the condition to let the code run regardless of the
value of 'results', you should be able to identify whether you have an
rs.eof problem (and therefore something wrong with your sql) or whether
the problem is in how you are defining 'results'.

--
Mike Brind