User Profile

Collapse

Profile Sidebar

Collapse
alpnz
alpnz
Last Activity: Jul 14 '10, 10:42 AM
Joined: Nov 8 '06
Location: New Zealand
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Many thanks for the advice it worked.

    Many thanks for the advice. Below is the resulting code
    Code:
    <?php
    error_reporting(E_ALL);
    ini_set('display_errors', true);
    $host = "localhost";
    $user = "wxoww";
    $pass = "password";
    $dbname = "wxoww";
    $datatbl= "tbl_owwdata";
    $connection = mysql_connect($host,$user,$pass);
    if(!$connection)
    ...
    See more | Go to post

    Leave a comment:


  • Many thanks ...

    Many thanks ...

    I got a basic line of data as per the plan however I would now like to present it in table form. This code produces the line, you will see that the commented out line however do not.

    Code:
    <?php
    error_reporting(E_ALL);
    ini_set('display_errors', true);
    
    $host = "localhost";
    $user = "wxoww";
    $pass = "password";
    ...
    See more | Go to post

    Leave a comment:


  • Still no joy,

    I get an empty screen with this, what have I missed
    Code:
    <?php
    $host = "localhost";
    $user = "wxoww";
    $pass = "password";
    $dbname = "wxoww";
    $datatbl= "tbl_owwdata";
    
    $connection = mysql_connect($host,$user,$pass);
    
    if(!$connection) ""  {
      die('Could not connect: ' . mysql_error());
    ...
    See more | Go to post

    Leave a comment:


  • alpnz
    started a topic Simple script failure ... any clues for a no clues user
    in PHP

    Simple script failure ... any clues for a no clues user

    I am trying to access data on a mySQL server, but due to my age and alzheimer's I seem to be overlooking the obvious mistake here. Anyone care to spare a couple of minutes to help.

    Code:
    <?
    $host = "localhost";
    $user = "root";
    $pass = "";
    $dbname = "wxoww";
    $datatbl= "tbl_owwdata";
    
    $connection = mysql_connect($host,$user,$pass) or die (mysql_errno().":
    ...
    See more | Go to post
    Last edited by Markus; Dec 16 '08, 12:47 AM. Reason: fixed [code] tags.

  • Ditto for me ... just had a call from an old client who cannot merge a document from his database ...
    Error #5852 Requested object is not available.
    It is a standard merge to Word document call from within an Access database. Chunders at the same place.
    See more | Go to post

    Leave a comment:


  • alpnz
    started a topic Help with a bash ftp script

    Help with a bash ftp script

    I keep getting an error on the windows login of the following script. Any ideas anyone?

    Code:
    #!/bin/sh
    #A script to move files across a network, which has strict firewalling, and only one gateway computer.
    #No issues with PASV other than it does not function well through the firewall.
    
    #Define the server to get the files from, and the files I want (It is a Windows ftp server, that I can connect too.)
    ...
    See more | Go to post

  • alpnz
    replied to Ka-ka kaching ... checking in ....
    Vegetarian Sausages ...
    Is that an oxymoron ?

    Curly Question #1:
    Is there some sort of Access to PHP form exporter tool out thar?
    See more | Go to post

    Leave a comment:


  • alpnz
    replied to Ka-ka kaching ... checking in ....
    Ye gods ... have you any idea what they make those things out of?...
    See more | Go to post

    Leave a comment:


  • M$ have had a small setback with a number of Govts adopting the odf standard ... guess they finally decided to cut the umbilca ......
    See more | Go to post

    Leave a comment:


  • Hi Mary .... I'll have a delve through the linux world ... there are a number of old libraries that could achieve this, or at least managed to convert from word, so surely reversable ... I presume M$SQL pkpk as the data server? although not important ... yes yes I know its been a long time .... my lightship broke down on the return journey ... but I'm back .... :-) xxx
    See more | Go to post

    Leave a comment:


  • alpnz
    started a topic Emailing reports as HTML formatted message ...

    Emailing reports as HTML formatted message ...

    Is there someone out thar that has managed to achieve this ... I have lots of really cool reports, that are printed and faxed, and OR sent as Snap files, but I would like to just send them as an HTML formatted message. It is possible, because Acclaim mange it very nicely with their Access based accounting package, See http://www.acclaim.co. nz Someone I am sure has been there done that, at the moment M$ seem to think that just selecting the HTML template...
    See more | Go to post

  • alpnz
    started a topic Ka-ka kaching ... checking in ....

    Ka-ka kaching ... checking in ....

    Hi all ... checking in after a long hiatus, major DB problem in the outer galaxy ... nothing to strenuous though ... bring me up to speed, whos in charge here now? :-)

    OOOO got a couple of curly questions too ... he he
    See more | Go to post

  • Search for DLookup in the help system, You will find help that documents another great way to display related information, using VBA code, great for just one off situations, and or conditional display. E.g. only display the information, if the criteria of a series of Dlookups is true or false etc etc.
    Welcome to the disease ... As Jim pointed out, this is where relational Databases get addictive.

    Hi all ... yes yes I know its been...
    See more | Go to post

    Leave a comment:


  • alpnz
    replied to VB compile error User defined Object
    So what was the outcome. Well after being buried in another project and not having time to dilly about on this, I finally sat down and had another go tonight. And you guessed it, I got it to work. Essentially I eliminated the obvious. and defined the data in the simplistic manner below.
    Code:
    'A sub routine to print directly to thermal printers with their own language set
    Private Sub create_eplab_Click()
    ' First sort out
    ...
    See more | Go to post

    Leave a comment:


  • alpnz
    replied to VB compile error User defined Object
    Thats a good question, I am not on the M$ box, so will have pop into the office and crank it up ... BUT
    Something I have checked over and over is,
    The spelling of the query and the 5-6 different ways of defining the query as a recordset.
    I have provided text as the variables, and the label prints, so it is definately the definition of the data source. The query works if opened in the database window, (and I supply the criteria for...
    See more | Go to post

    Leave a comment:


  • alpnz
    replied to VB compile error User defined Object
    By that I presume, "Is there a Query in the query window of the database called 'qry_elabel'?, the answer is yes, but that is a good question, because if I select 'crtl' 'space' at each step as I type in the objects, I would have expected the queries to have shown up, under say "DoCmd.OpenQuer y "should show up in the object list at this point" ??? ..
    JS
    See more | Go to post

    Leave a comment:


  • alpnz
    replied to VB compile error User defined Object
    Hi Mary, Thanks for the reply ..

    I had tried this early on, (Admittedly after sorting out the DAO stuff) but got a Runtime Error of '3061', Too few parameters expected 1. (It highlights the myset = statement in the debug )

    The Query SQL is above somewhere in this thread, it works just fine if you run it on its own and feed the criteria of the PakTrakID, so we know the dataset is there. I have also tried a long winded SQL...
    See more | Go to post

    Leave a comment:


  • alpnz
    replied to VB compile error User defined Object
    At presant the code bombs out I think due to me not defining the data source correctly. The code at the moment.
    Code:
    Private Sub create_eplab_Click()
    ' First sort out the variables. Including label content, quantity to print etc
    
    	
    	Dim var1 As String
    	Dim var2 As String
    	Dim var3 As String
    	Dim var4 As String
    	Dim var5 As String
    	Dim qty As Integer
    ' Sort out where the data is coming
    ...
    See more | Go to post

    Leave a comment:


  • alpnz
    replied to VB compile error User defined Object
    Adrian,
    Would that be the more sensible way to define the recordset. As you know I do not do enough of this to be conversant, in the howto. I might have done it long ago, does not mean I know how to do it now. :-)

    John S...
    See more | Go to post

    Leave a comment:


  • alpnz
    replied to VB compile error User defined Object
    Such a simple thing. Why is it selected in the development database, I certainly did not select it?.

    The code now debus to the mydb.OpenRecord set(sql_rst) line. I wonder why not refer directly to mydb."qry_elabe l" as the recordset.
    Code:
    Private Sub create_eplab_Click()
    ' First sort out the variables. Including label content, quantity to print etc
    
    	
    	Dim var1 As String
    	Dim var2
    ...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...