Sagewire Logo

Frame works in some websites, not others

14 Message(s) by 5 Author(s) originally posted in cfml database access


From: Kapman78 Date:   Saturday, October 13, 2007
I think one is a duesy, but I hope someone has some insight, thanks is advance
for any attempt.

I have a bookmaking website that opens other websites in a frame . Within the
frame I have a link s that tie into the database so they can add it as a
favorite or rank the site. The problem is some sites wont work, about 80% do,
but there are a couple that give me the error below. I'm assuming they have
some kind of frame blocker or something. Let me know, thanks!

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft ][ODBC Microsoft
Access Driver]Numeric value out of range (null)

Please try the following:
? Enable Robust Exception Information to provide greater detail about the
source of errors. In the Administrator, click Debugging & Logging > Debugging
Settings, and select the Robust Exception Information option.
? Check the Cold Fusion documentation to verify that you are using the correct
syntax.
? Search the Knowledge Base to find a solution to your problem.

Here is a link to a non-working:
http://www.busswire.com/frame2.cfm?CFID=141904&CFTOKEN=14129363

working: http://www.busswire.com/frame2.cfm?CFID=141904&CFTOKEN=14129363

Thanks


From: cf_dev2 Date:   Saturday, October 13, 2007
Neither link works. The error I get is Element AUTH.SITE is undefined in SESSION.


From: Kapman78 Date:   Sunday, October 14, 2007
Well forget the links, the site is in development right now. Any ideas?


From: cf_dev2 Date:   Sunday, October 14, 2007
Not without seeing the full error message, including the sql query generated and the values passed, no.


From: Kapman78 Date:   Sunday, October 14, 2007
Found the problem, wacky but this was the query in the frame:
total/votes AS stars, round(stars) AS nstars
<CFQUERY datasource="buss" name="whatup">
Select website, catagoryb, about, quickname, votes, commentcount, total/votes
AS stars, round(stars) AS nstars
FROM websites
WHERE sitenum = #session.auth.site#
</CFQUERY>

Still not sure why but some websites didnt like "total/votes AS stars,
round(stars) AS nstars" if I remove those two all is well.

Anyone understand why this is happening?


From: cf_dev2 Date:   Sunday, October 14, 2007
total/votes AS stars, round(stars) AS nstars



Is "stars" an actual column in your table or just an alias for (total/votes)?


From: Kapman78 Date:   Monday, October 15, 2007
No it's not in my table, its just an alias


From: cf_dev2 Date:   Monday, October 15, 2007
round(stars) AS nstars



Afaik you cannot use an "alias" like that. You should be using the actual column names in your round function.


From: Azadi Date:   Tuesday, October 16, 2007
just a wild guess:

it errors when votes=0 ???

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com


From: Kapman78 Date:   Tuesday, October 16, 2007
Do you know why? I'm just curious why it works for most sties within the frame, and just a small few it does not? Thanks


From: cf_dev2 Date:   Tuesday, October 16, 2007
I do not know. I think need to do some debugging to try and get more
information about the cause of the error. If its really is caused by one of
those two statements, try and figure out which one (or if its both). I'd
also check the column types and compare the "total" and "vote" values for sites
that [b]do[/b] cause the error against sites that do not. Figure out what is
different about them, are specific values causing the error, etc.


From: Adam Cameron Date:   Tuesday, October 16, 2007
I think Azadi's got your answer here, but I'd just like to raise one issue
with your expectations here.

I'm just curious why it works for most sties within the frame, and just a small few it does not? Thanks


ColdFusion has no idea about the concept of "frames" (one way or the other). ColdFusion
runs on the ColdFusion server , processes a request passed to it by the web server,
and sends a response back to the web server. The web server relays that
back to the browser . Only the browser knows that it has to render the
response in a frame. Neither ColdFusion nor the web server know or care.

I point this out because when you're troubleshooting ColdFusion issues, there's no
point worrying or wondering about whether the fact your using frames has
*anything at all* to do with it.

--
Adam


From: cf_dev2 Date:   Tuesday, October 16, 2007
just a wild guess:
it errors when votes=0 ???



Surprising that would not return a division by zero error. Perhaps thats too explicit for Access.


From: Kaplanconstruct Date:   Sunday, October 21, 2007
Thanks everyone for the feedback. I plan on looking into this issue more later
but I have bigger fish to fry. Even more so because there are quite a few
websites out there throwing frame breakers. When I get back to this I'll post
the outcome. Just an FYI I had commented out all the ranking and still had the
issue. Thanks again!!



Next Message: Passing parameter to Oracler function


Blogs related to Frame works in some websites, not others

Character, cast, and production information, as well as episode ...
www.jacksonavenueschool.com ventilator associated pneumonia kevin brosnan doctors home experience positive board thread vip rate message barnesansnoble embassey suites louis sauter greek impetigo not crusting fantasy football website ...

This website will help you to find out everything you need to know ...
rna virus retroviruses website for guidance Topic some people believe that advertising is generally helpful and others believe that it is generally harmful. discuss your ideas aaa discounts in new york city. ...

Microsoft and Zend taking PHP on Windows to the next level !
NET Framework’s CLR? Why not? A: While we expect that some developers will want to choose Phalanger, we know that others are interested in staying with the PHP runtime while looking for ways to leverage Windows features. ...

The official Magazine Website features news and tests.
ladies rolex frame graft on 1947 chev fleetline road house exhaust remove virusprotect virgin.com.au sport injurys fatai dosunmu vnc for pc initial needed work apparently assumption fix installed notification problem treo sata notebook ...

All the information. Limited offers.
thai baht gold jewelry poke a womon castles scotland hotel remax realty mt vernon ohio cheverolet s10 pickup gauges not working birds with avian flu in germany work force optimisation naked women bachelor party sheba lane craig carton ...

Magazine publishing independent motor news and reviews.
Coarsegold elementary school fashion gallery virginia (janet lynn pressler duke) public works commission nc male physical exam john mooney - tv what is good for them and what is not bush best wax as you dry mild herpes picture dawn ...


Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional