www.webdeveloper.com

Search:

Type: Posts; User: Adders

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    1,360

    All sorted, put a character in the wrong place.

    All sorted, put a character in the wrong place.
  2. Replies
    1
    Views
    1,360

    SQL / ASP replace character

    Hi,

    I'm currently trying to export data from an sql table to a CSV file using classic asp, this has worked absolutely fine except one column partdesc has several commas in which causes the import...
  3. No not at all, I just want a connection that will...

    No not at all, I just want a connection that will connect up to the database, using DSN or not just doesn't seem to work :(
  4. Database connection from one server to another

    Hi,

    I'm having trouble connecting to a database on another server. I have setup the DSN which in testing works perfect. However when running the asp script with the follwing code:

    <%
    ...
  5. Replacing NULL values when selecting from an excel spreadsheet

    Hi,

    I have the following select statement:


    `Dim rsGetInvoiceContact
    Dim rsGetInvoiceContact_numRows

    Set rsGetInvoiceContact = Server.CreateObject("ADODB.Recordset")
    ...
  6. Replies
    1
    Views
    1,202

    Wrong number of arguments

    Hi,

    I now seem to get his error: Microsoft VBScript runtime error '800a01c2' Wrong number of arguments or invalid property assignment: 'FGetnlCode'

    I cant really see why this is happening? the...
  7. All Sorted my end, trying to use an incorrect...

    All Sorted my end, trying to use an incorrect value against the database!
  8. Microsoft VBScript runtime error '800a01a8' Object required: ''

    Hi,

    I'm really struggling to display the following:

    <%response.Write(rsGetEFACsIAdd.Fields.Item("contactid").value)%>

    The error Object required: '' is shown when running the code?

    I'm...
  9. Thread: Form action

    by Adders
    Replies
    3
    Views
    1,212

    When logged in I'm directed to the URL:...

    When logged in I'm directed to the URL: loggedIn/invoice.asp?loggedIn=1 which gives me 3 submit buttons.

    I have since created a new page so that when I login I'm directed to the new URL which has...
  10. Thread: Form action

    by Adders
    Replies
    3
    Views
    1,212

    Form action

    Hi,

    I have a form action: <form action="?login=1" method="post"> however the actual url is ../invoice.asp?loggedIn=1

    I want to be able to have the url being: ../invoicecar.asp?loggedIn=1 which...
  11. Replies
    2
    Views
    1,669

    Worked like a treat thanks.

    Worked like a treat thanks.
  12. Replies
    2
    Views
    1,669

    Bad file name or number

    Hi,

    I recently noticed that some of my code that used to work now displays an error: Bad file name or number

    <%Session("file") = request.Querystring("Filedata")
    xmlfile = (session("file"))%> ...
  13. Replies
    9
    Views
    2,489

    Unfortunately I'm extremely new to SQL and...

    Unfortunately I'm extremely new to SQL and changing someone elses code is some what tricky.

    All sources are located on the same server.

    I have looked in the registery and it appears that mysql...
  14. Replies
    9
    Views
    2,489

    The code I'm running is below: Dim...

    The code I'm running is below:

    Dim rsSelectOrder
    Dim rsSelectOrder_numRows

    Set rsSelectOrder = Server.CreateObject("ADODB.Recordset")
    rsSelectOrder.ActiveConnection =...
  15. Replies
    9
    Views
    2,489

    Thanks for the link. I have tried all the...

    Thanks for the link. I have tried all the suggestions where a now see the below error.

    I have even tried making the changes within the registory but with no joy!

    Microsoft OLE DB Provider for...
  16. Replies
    9
    Views
    2,489

    Just as to why the code doesn't work? I am...

    Just as to why the code doesn't work? I am transferring the system from server 2000 to server 2008 where the code used to work fine. The error I get is:

    Microsoft OLE DB Provider for ODBC Drivers...
  17. Replies
    9
    Views
    2,489

    OPENROWSET Error on local server

    Hi,

    I'm trying to run the following OPENROWSET code on the local server, however it asks for ad hoc to be turend on? I have tried this but it seems to be only needed for a remote server? When it...
  18. Still having no joy in implimenting a solution....

    Still having no joy in implimenting a solution. the date format in the database is yyyy-mm-dd, is there away to just search for the date and not worry about the time as I just need deliverys for that...
  19. Hi Ribs, Thanks for your response! ...

    Hi Ribs,

    Thanks for your response!

    Unfortunately I'm still seeing the error even thou the output is returning true.

    Dim rsgetdelv
    Dim rsgetdelv_numRows
    dateVar = year(date()) & "-" &...
  20. Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

    [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

    I am having trouble in creating a date and time to...
  21. Replies
    2
    Views
    1,200

    Thanks for the reply. I am using the following...

    Thanks for the reply.

    I am using the following PHP tags:

    <?php
    $selectemail = $_REQUEST['selectemail'];
    $name = $_REQUEST['name'];
    $email = $_REQUEST['email'];
    $subject =...
  22. Replies
    2
    Views
    1,200

    unexpected T_ELSE Line 32

    Unable to locate error on line 32?

    if($newsletter) {
    $newsletter = "Yes";}

    $con = mysql_connect("EFACSSERVER","IUSR_RFS01","splendid");
    if (!$con)
    {
    die('Could not connect: ' ....
  23. Replies
    3
    Views
    2,173

    Storing Sql in a session

    Hi,

    Is it possible to store SQL code in a session to be displayed on the next page?

    Code: <%=formatCurrency(myQuery("proFormaAmount"), 2)%>

    Or can i save it as variable?

    I have tried...
  24. Replies
    1
    Views
    1,485

    Querying two columns against another

    Hi,

    I would like to able to to display all bomchild parts that are not PG50 within bomparents that are PG50 so i can PG50 those parts that are no longer used?

    I have a joined table with...
  25. Replies
    69
    Views
    22,986

    Thanks Ribs, Works like a treat. I now only...

    Thanks Ribs,

    Works like a treat. I now only have one last query to complete my system.

    Is it possible when querying the database:

    mySQL = "SELECT scustordnum, sonitem, spart, suom, soq,...
Results 1 to 25 of 59
Page 1 of 3 1 2 3
HTML5 Development Center



Recent Articles