Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default What is this?

    Error Executing Database Query.
    [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
    Access Driver] Too few parameters. Expected 1.

    The error occurred in D:\home\hnt20a071\sigmachi_en\root\site.cfm: line 10

    8 : <cfquery name="Article" datasource="SigmaChi">
    9 : SELECT * FROM WebArticles
    10 : WHERE PageName = #url.PageID#
    11 : AND PageOrder > "0"
    12 : ORDER BY PageOrder ASC

    i need some help. this application works on my server on my computer but when
    i uploaded it to the web server it dose this!!
    please any help would be awesome!
    thanks,
    chill

    chill84 Guest

  2. #2

    Default Re: What is this?

    Is pagename a number or text ?
    If it's a number then it's okay, If it's text then the cf variable needs to be
    enclosed in single quotes
    WHERE PageName = '#url.PageID#'

    Is pageorder a number or text
    If it's a number then it should be
    AND PageOrder > 0

    If it's text, then it should be
    AND PageOrder > '0'

    But it makes no sence to be seeing if some text is greater than '0'

    Ken


    The ScareCrow Guest

  3. #3

    Default What is This?

    What does this code mean and what does it do? :confused;
    <META NAME="robots" CONTENT="index all, follow all">

    Can anyone give me a concise description?

    In other words, not just :sad; > It tells "robots" to run through your
    site, or Why do you want to know, or it depends on "---", or it only works on
    "---"
    , etc.

    Thanks in advance for helpful, clear, pertinent, concise responses :smile;

    CSUjr Guest

  4. #4

    Default Re: What is This?

    It tells the search engine robots to index this page and to follow all the
    links it finds on this page so that it can index those other pages at those
    links.

    --
    Murray --- ICQ 71997575
    Adobe Community Expert
    (If you *MUST* email me, don't LAUGH when you do so!)
    ==================
    [url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
    [url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
    [url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
    ==================


    "CSUjr" <webforumsuser@macromedia.com> wrote in message
    news:e7mscc$p7f$1@forums.macromedia.com...
    > What does this code mean and what does it do? :confused;
    > <META NAME="robots" CONTENT="index all, follow all">
    >
    > Can anyone give me a concise description?
    >
    > In other words, not just :sad; > It tells "robots" to run through your
    > site, or Why do you want to know, or it depends on "---", or it only works
    > on
    > "---"
    , etc.
    >
    > Thanks in advance for helpful, clear, pertinent, concise responses :smile;
    >

    Murray *ACE* Guest

  5. #5

    Default What is this?

    In this attached
    [url]http://new.photos.yahoo.com/bikeopellie/album/576460762322930355/photo/294928803[/url]
    267410727/0 (taken during a Contribute Edit session) I have some examples of
    jpg's as they exist on a web page created with Golive. I have deleted the
    actual jpg's in the last 2 examples.
    The web site containing this page is... [url]http://www.marthareisdorf.com/[/url]
    While I am new to this stuff I have tried to find out just what the border
    with the small box (upper left) is, and is called.
    Its pretty handy because in Contribute 'Edit' , if I click on the jpg and this
    border appears, I can easily move the jpg around the page with drag and drop
    after the cursor changes to a 4 way arrow. I am guessing this was created by
    Golive but I don't have it.
    I would like to incorperate this feature in a new web page but have not been
    able to figure out how...


    fatfenders Guest

  6. #6

    Default Re: What is this?

    Hi,

    What you are referring to are layers. Unfortunately, you cannot insert new
    layers on your pages using Contribute. If you like to do more complex layouts,
    we would recommend that you try using Dreamweaver.

    Dreamweaver Trial downloads:
    [url]http://www.adobe.com/cfusion/tdrc/index.cfm?product=dreamweaver&loc=en_us[/url]

    HTH.


    AndrewDG-MMTS Guest

  7. #7

    Default What is this?

    Whilst viewing a movie on youtube, this thing appeared right in the middle of
    the screen, and I could not get rid of it.
    [url]http://www.picturetrunk.com/2006/11022006/407a30939e.jpg[/url]
    I clicked on "Deny" and nothing happened, it remained there. I am using Macs,
    so I dont think its a virus or anything bad. But what is it? Does it have
    anything to do with Adobe Flash?
    :confused;
    Thank you in advance,
    Jane

    falmouthcapecod Guest

  8. #8

    Default Re: What is this?

    Seems that nobody here knows what this is, so it must not be anything connected
    with Adobe.
    I will tell all my classmates, to click out of the page that they are looking
    at, when it displays this odd message.
    Its just some pop up advertisement for something that we should not want.
    Rest assured that we Mac people wont have a problem with it, just dump it.
    Just terminate the page you are looking at, if this odd message appears, since
    nobody has a clue.
    Ive been able to open the same page later on with Firefox, and not seen this
    intrusive thing.
    Jane

    falmouthcapecod Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139