dickersonka 104 Veteran Poster

You should have it, but here's the link

http://java.sun.com/products/java-media/sound/index.jsp

dickersonka 104 Veteran Poster

yes, very common problem

i'll help you solve it

before executing the query, echo it and you can see whats wrong

echo $query;
dickersonka 104 Veteran Poster

Might want to take a look at your maxworkerthreads, also who knows about your system and the max load it can handle

http://msdn.microsoft.com/en-us/magazine/cc164128.aspx

dickersonka 104 Veteran Poster

I think you are in the right forum, just not a widely distributed topic.

This might be of use
http://www.ibm.com/developerworks/library/pa-emulation.html

dickersonka 104 Veteran Poster

when setting the result change it to this, and try again

$result = mysql_query($query) or die (mysql_error());
dickersonka 104 Veteran Poster

to log in with credentials you can call it by

mysql -u username -p

dickersonka 104 Veteran Poster

Hmmm might not have completed the install properly.

Go into services.msc and check and see if your sql server reporting services exists

dickersonka 104 Veteran Poster

NewUserId will be PurchaseOrderId

make sure you have this in the stored procedure as well, like we said before

@PurchaseOrderId int OUTPUT

also make sure if you modified the code it is cmd not cmdl, unless you changed the name

dickersonka 104 Veteran Poster

Yes, for future reference it is normally called masking or password masking

Here's the link

http://java.sun.com/developer/technicalArticles/Security/pwordmask/

dickersonka 104 Veteran Poster

sorry, this way does use the way we had first with
OUTPUT and select @PurchaseOrderID = @@IDENTITY

so change it back to that to follow that example, no more changes now :-)

dickersonka 104 Veteran Poster

yes that is what i mean

it was just code, but anyways
here's a better link

http://www.dotnetjunkies.com/WebLog/skiff/archive/2005/02/12/54047.aspx

dickersonka 104 Veteran Poster
dickersonka 104 Veteran Poster

Here's a link

http://blogs.msdn.com/vsdata/archive/2006/08/21/711310.aspx

you can change your stored procedure, by removing the "OUT" parameter, and instead of
select @PurchaseOrderId = @@IDENTITY

you just use return @@IDENTITY

dickersonka 104 Veteran Poster

the problem is that when you execute the first query, it is returning your purchaseorderid, which links the purchaseorderdetails to it

you need to pass this in as a parameter from code side

dickersonka 104 Veteran Poster

Add the code to what a form?

dickersonka 104 Veteran Poster

And just as good practice, a database is there for the organization, it doesn't need to be in sequential order.

It may look prettier to you if it is, but just add an order by user_id or whatever it may be to your query, trying to update id's all over the place is a pain in the a@@ if you don't have the correct set of foreign keys in place

dickersonka 104 Veteran Poster

i don't have a clear idea of what you are wanting

the message_from field has a 3 and it needs to be a 104?

dickersonka 104 Veteran Poster

here's a tip

use while loops when you don't know the number of iterations (you never know when the user will type "no")

use a for loop for a known size
(for each hour in the day, have 5 records)

dickersonka 104 Veteran Poster

you can use a modal popup, show some work and we'll give some further help

dickersonka 104 Veteran Poster

wish i did, this one seems to be a doozy

what about changing the location of these files to another directory?
maybe some mysterious directory security issue

dickersonka 104 Veteran Poster

Has anyone noticed sometimes you'll receive an email after someone has posted to a subscribed thread right away, while other times it may take a few hours to receive the email?

dickersonka 104 Veteran Poster

Sure thing, always show your effort and we will be more than willing to help

dickersonka 104 Veteran Poster

purchaseorderdetails
PURCHASE_ORDER_DETAILS_ID
PURCHASE_ORDER_ID
ITEM_ID
ITEM_AMOUNT

create procedure sp_AddPurchaseOrderDetails
(
   @PurchaseOrderId int,
   @ItemId int,
   @ItemAmount decimal(10,2),
   @PurchaseOrderDetailsId int OUTPUT
)
as

insert into PurchaseOrderDetails (PURCHASE_ORDER_ID, ITEM_ID, ITEM_AMOUNT) values (@PurchaseOrderId, @ItemId, @ItemAmount)

select @PurchaseOrderDetailsId = @@IDENTITY
dickersonka 104 Veteran Poster

Ok, so you are meaning its correct then?

dickersonka 104 Veteran Poster

Sure, i don't understand how you are "accessing" this other program though.

dickersonka 104 Veteran Poster

close, you need to make the loop go outside of all that, also please place code in code tags

System.out.println(" Do you want to enter information ?");
String choose = input.nextLine();

while(choose.equals("yes")) {
System.out.println(" What is your name ? ");
String name = input.nextLine();

System.out.println(" What is your age ?");
String age = input.nextLine();

System.out.println(" What is your ssn ?");
String ssn = input.nextLine();

System.out.println(" What is your address ?");
String address = input.nextLine();

System.out.println(" Do you wish to make another entry ?");
choose = input.nextLine();
}
dickersonka 104 Veteran Poster
string sCxn = "server=myServer;Integrated Security=SSPI; database=master";
string insertQuery = "INSERT ....";
SqlConnection myConnection = new SqlConnection(sCxn);

try
{    
SqlCommand  myCommand = new SqlCommand(insertQuery, myConnection);
myConnection.Open();  
myCommand.ExecuteNonQuery();
}
catch(Exception e)
{
    Console.WriteLine(e.ToString());
}
finally
{
  myConnection.Close();
}
dickersonka 104 Veteran Poster

ahhh, now with the document i see how volunteers are related


volunteers
VOLUNTEER_ID
NAME
TELEPHONE
ADDRESS

volunteerservicesprovided
VOLUNTEER_SERVICE_ID (optional)
VOLUNTEER_ID
SERVICE_CODE

change booking records to this

bookingrecords
CLIENT_ID
DATE
REQUIRED_HOURS
REQUIRED_SERVICE_CODE
VOLUNTEER_ID

this way, if a volunteer ever changes his service offered, you still have record of which volunteer did the service

dickersonka 104 Veteran Poster

then this table structure should work for you

dickersonka 104 Veteran Poster

I know they continued into the 90's but how about Tom Petty and Sting

dickersonka 104 Veteran Poster

also you will crash out past once x hits 10, your table is only of size 10

Alex Edwards commented: Good catch =) +4
dickersonka 104 Veteran Poster

top

dickersonka 104 Veteran Poster

I don't necessarily know where to start for a complete OS, but I have made drivers before.

You can find a forum, and articles and what not at
www.osronline.com

This is a primarily windows site btw, but many drivers at least share a lot of similarities.

dickersonka 104 Veteran Poster

try changing your code to this, at least while debugging

for (int i =0; i<Files2Delete.size(); i++)
 {
     String path = Files2Delete.get(i);
      File f = new File(path);  
      System.out.println("File: " + path + "canonical path: " + f.getAbsolutePath() + 
        			" can write:" + f.canWrite() + " can read" + f.canRead());
      f.delete();
}
dickersonka 104 Veteran Poster

ahhhh, when you create the files did you call the close() method?

dickersonka 104 Veteran Poster

looks to be ok

are the files open and you have permissions to them?

dickersonka 104 Veteran Poster

scratch my last post, you are adding strings

What does the println show you before the delete?

dickersonka 104 Veteran Poster

Are they List<File> or List<String>?

From what you described it sounds like file if so you can use this

Files2Delete.get(i).delete();
dickersonka 104 Veteran Poster

short answer: yes (if you have permissions)

long answer: sort of, you can delete directories with this as well, but if its a directory thats not empty, it will not delete, ensure your files are not directories

dickersonka 104 Veteran Poster

Definitely agree with ezzaral. Get your path, then println it, then call delete.

Also there are numerous things that could go wrong with file access/permissions. Make sure you either throw the exception or catch it and println it as well

dickersonka 104 Veteran Poster

sure, you had a good start on the first one
we'll do the purchaseorder

create procedure sp_AddPurchaseOrder
(
   @POInputDate smalldatetime,
   @PurchaseOrderId int OUTPUT
)
as

insert into PurchaseOrder (PO_DATE) values (@POInputDate)

select @PurchaseOrderId = @@IDENTITY

then you will use the same concept for creating purchaseorderdetails, except you will pass in the purchaseorderid as a parameter

(btw i just used the date column, and not client_id like we talked about before)

dickersonka 104 Veteran Poster

Although you aren't passing arrays, you should return the id of the purchase order to your code.

Then call a stored procedure for sp_AddPurchaseOrderDetails for each item you have, 1 item 1 call, 3 items 3 calls

dickersonka 104 Veteran Poster

Here's a codeproject article that describes it

http://www.codeproject.com/KB/miscctrl/imapi2.aspx?fid=1134078&df=90&mpp=25&noise=3&sort=Position&view=Quick&fr=51&select=2553392

I don't think you will be able to do this using straight C# without interop, but I don't know if you are meaning not to use interop

dickersonka 104 Veteran Poster

Myself, I wouldn't normally go the formatting route for examples just for readability, very nice touch though.

dickersonka 104 Veteran Poster

Nice one ddanbe

Here's c++ version, i stayed with separating couts rather than using formatting

for (int x = 0; x <= 8; x+=3)            
{                
cout << x << "\t" << x+1 << "\t" << x+ 2 << "\n";            
}
dickersonka 104 Veteran Poster

the problem looks to be this inside of stop_sub

commandString = fileScan.next ();

there is no command with it, therfore you are reading "output" inside of the stop_sub section

dickersonka 104 Veteran Poster

If only it was that easy. It takes a rewrite.

dickersonka 104 Veteran Poster

I'll give you a place to start

The problem you are running into is with indexing urls that are "urlrewrite"

This isn't specific to horse racing, its widely used, but theres a place to start

dickersonka 104 Veteran Poster

are you able to run multiple queries on number 1 or need a single one?
the concept is pretty much there though

number 3 you have the concept as well
here's some help, depending upon what db you are using

select sname, lname from staff where
manno in (
select instructor.manno
from instructor
inner join examiners
on instructor.manno = examiners.manno)
dickersonka 104 Veteran Poster

create a new thread rather than posting in this thread and we might be able to