Results 1 to 7 of 7

Thread: Random Error... [RESOLVED]

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2004
    Posts
    56

    Random Error... [RESOLVED]

    Getting the following error just wondered if anyone had any ideas.

    heres the code first of all...

    Code:
     <%
    
    response.ContentType = "text/xml"
    
    Set ObjConn = Server.CreateObject("ADODB.Connection")
    ObjConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("xml.mdb")
    ObjConn.Open
    
    response.write("<?xml version='1.0' encoding='ISO-8859-1'?>")
    response.write("<orderform>")
    
    while (not rs.EOF)
    
    response.write("<tetxboxs>")
    
            response.write("<firstname desc='Firstname' size='20' type='INPUT'/>")
            response.write("<lastname desc='Lastname' size='20' type='INPUT'/>")
            response.write("<houseno desc='House Number/Name' size='20' type='INPUT'/>")
            response.write("<street desc='Street' size='20' type='INPUT'/>")
            response.write("<town desc='Town / City' size='20' type='INPUT'/>")
            response.write("<county desc='Country' size='20' type='INPUT'/>")
            response.write("<postcode desc='Postcode' size='20' type='INPUT'/>")
            response.write("<hometel desc='Home Tel' size='20' type='INPUT'/>")
            response.write("<worktel desc='Work Tel' size='20' type='INPUT'/>")
            response.write("<email desc='E-Mail' size='20' type='INPUT'/>")
    
    response.write ("</textboxs>")
    
    rs.MoveNext()
    
    wend
    
    rs.close()
    
    ObjConn.close()
    
    response.write("</orderform>")
    
    %>
    And the error i'm getting is...

    A string literal was expected, but no opening quote character was found. Error processing resource 'http://mmtprojects.herts.ac.uk/year4/MMT4-30/XML%20Group%2047/order.asp'. Line 1, Position 80

    <?xml version='1.0' encoding='ISO-8859-1'?><orderform> <font face="Arial" size=2>
    -------------------------------------------------------------------------------^

    yet i can't find the line regarding this, is it some kind of default error? Also At the moment these will be a some input boxes, how would i change this into a form? Quite new to XML and can't find anywhere that helps really. I assume it has to be done here and not in the XSL file that will eventually be accompanying it. Anyways any help and/or suggestions would be much appriciated!
    Last edited by MavsteR; May 3rd, 2004 at 07:32 AM.

  2. #2
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    It's the XSL that has to transform it into a HTML form (if that's what you want).

    Can't help you with the error though.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.

  3. #3

    Thread Starter
    Member
    Join Date
    Mar 2004
    Posts
    56
    thanks for the help, havn't been able to figure the error out yet, i assume i'm missing something from my code, gonna have to spend a few hours checking google!

    Regarding the form however, will it just be done via the XSL:attribute tag to create the form or can i jsut use standard HTML formatting?

  4. #4
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    Depends on what you want to do. xsl:attribute is only needed when you want to fill the attribute with something from the XML document, like an initial content.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.

  5. #5

    Thread Starter
    Member
    Join Date
    Mar 2004
    Posts
    56
    ah so if i wanted just a standard form then i can just use html coding?

  6. #6
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    Yeah, I think so, though I'm not exactly sure what you want to achieve.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.

  7. #7

    Thread Starter
    Member
    Join Date
    Mar 2004
    Posts
    56
    sorted all my problems were caused by my own stupidity thanx anyways

Posting Permissions

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



Click Here to Expand Forum to Full Width