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