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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- romerz
- Thread
- Replies: 2
- Forum: Microsoft: Windows servers
-
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...- romerz
- Thread
- Replies: 4
- Forum: Microsoft: Windows servers
-
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 =... -
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?- romerz
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
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... -
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 ->... -
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) {...- romerz
- Thread
- Replies: 2
- Forum: Javascript
-
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 =... -
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 =... -
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; }
