Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: romerz
  • Content: Threads
  • Order by date
  1. romerz

    VPN Internet Split

    Good Afternoon, I have someone connecting to my 2003 server via their broadband connection. This works fine, they can login and view all of the files on the server. The problem is, once they are connected to the VPN - they can no longer use the internet on their machine. Is there a way round...
  2. romerz

    Sharing Files and Folders

    Hello, I have windows 2003 running as a DHCP server, and it apears to work fine as that (currently anyway). However, I want to be able to share a folder (basically being a file server aswell) with windows XP Pro machines. Ive created the folder, set it to share with unlimited connections, and...
  3. romerz

    An SQL statement inside a while loop?

    Is this possible? Im recieved errors each time I try. $sql = "SELECT * FROM WS_Orders WHERE ws_john2_number2=$order_no"; &reportError("Unable to open Orders Table : " . $DB->Error()) if ($DB->Sql($sql)); while ($DB->FetchRow()) { %row = $DB->DataHash(); $order_orderdate =...
  4. romerz

    access, to .SQL

    Im not 100% sure however, the database was created in access and needs to be changed into an .sql file. It needs to be converted somehow, not by changing the tables etc into csv files and importing them. Is there anyway to do this?
  5. romerz

    writing a var to a txt file

    I have a file named returns.txt I have the sql working correctly, if i just use print $orderId; print "<br>"; it lists everything I would expect. However this doesnt seem to work. open (RETURNFILE, '>returns.txt'); print RETURNFILE $orderId clode (MYFILE); Have I missed something, or...
  6. romerz

    SQL showing more than wanted

    The code that works is "SELECT * FROM Orders WHERE ( (orderStatusId >=3) AND (orderStatusId <=5) ) AND (john_text3 <> 'TDC') AND (john_text3 <> '')" "ORDER BY john_text3, orderId" But i need to join the orders table onto the transactionEntryItems table. it goes this way Orders ->...
  7. romerz

    Javascript validation option box

    Basically I have a form that has -------------------------------- as an option to make a line (because the options in the drop down box are coming from a database) I have validation for everything, the bit that checks that something has been selected is x=frm.country[0]; if (x.selected) {...
  8. romerz

    SQL INNER JOIN ERROR

    $sql = "SELECT Orders.john_text3, Orders.orderDate, Orders.orderId, Orders.john_tex10, Orders.total, TransactionEntryItems.returnDate"; #$sql.= "FROM ((Orders INNER JOIN Transactions on Orders.orderId = Transactions.orderId) INNER JOIN TransactionEntries ON Transactions.transactionId =...
  9. romerz

    SQL Inner join + normal

    SELECT Orders.orderId, Orders.total, Orders.orderDate, Orders.name, Orders.city, Orders.orderStatusId, TransactionEntryItems.garmentSizeId, GarmentStockCodes.stockLevel, GarmentStockCodes.CJC_sub_weight2, TransactionEntryItems.garmentId FROM (((Orders INNER JOIN Transactions ON Orders.orderId =...
  10. romerz

    What is wrong with my code: tryign to read a text file

    #!/usr/bin/perl print "Content-type: text/plain\n\n"; open(FH,"test.txt") or &dienice("Can"t open test.txt: $!"); my @ary = <FH>; close(FH); foreach my $line (@ary) { print $line; }

Part and Inventory Search

Back
Top