:wtf:

Quote:

It's called free advice, and sometimes comes unsollicited.

So do STDs but that doesn't mean I need them

Mind-reading is a great feature to have. This way you know what I want better than me... oh wait; you don't and yet you assumed otherwise anyway

I did move on. Until someone gave an answer to my question which was all i needed to know. Why do some people think that a question must always be answered with with an assumption that everything you do is wrong and you should change your thinking according to theirs? Did any of you even bothered to ask why I needed the answer to that question? (except the 2 straight to the point answers - thanks again). No you didn't. You just assumed it is something vital to what I do and you advised me to change my logic. So to sum it up and end this hopefully: - i got the answer I needed which is great - i was looking for an answer and not a solution - the mayans were wrong about the world end (along with whoever misunderstood what they were trying to say) - check above fact and see if you find any analogy with this now turning into a flame thread Thanks

Thanks guys. Exactly what I needed to find out.

Rude? If I didn't need the answer I wouldn't have asked the question.

Thanks guys. Exactly what I needed to find out.

Ok so you don't know. Anyone else?

I'm trying to find the answer to this question. Let's say you have a MSSQL database which has a table with an auto-incremented field. If I have a Sql transaction sent to the server (through code) that does an insert into that table and the transaction fails (and does a rollback) will the current ID be lost or not? When does it generate the new ID? At transaction start or finish? Ex: table1 has column ID as auto-increment. the current ID is 100. If I send a transaction with an insert does is reserve the ID 101 and loose it if the transaction fails with rollback, meaning next ID would be 102? Or will it take the ID 101 only if the transaction commits successfully? thanks

nvm

to make sure it was scanned correctly and all the elements are written correctly

why what? add it? because i have a xsd file to verify the xml which requires the namespace (otherwise it cannot validate the xml)

right back at you

:sigh:

I have a xml file scanned from a 2d barcode. The creator decided not to include the namespace info into the code so i have to add it after scanning the file. How can I do it in java?

i am commiting the changes. i have also tried to unlock tables before alter but to no success. think i have to re-think the whole process.

Hello, I have the following situation which I can seem to resolve. When I do an "ALTER TABLE" in mysql (v5.5) it hangs in with "waiting for metadata lock". Here is how I got there: - i have an xml which i want to import into a table; i use the elements in the xml to create columns in the table like this: XML example

some name

dsada

there are some nodes in the xml that have different number of elements, like:
<name> some name </name> <address>ds adsa</address> <phone> fndjsf</phone>

SQL queries

create table `person` ( `id` bigint(12) unsigned NOT NULL auto_increment ,`name` varchar(200) NOT NULL ,`address` varchar(250) NOT NULL ,PRIMARY KEY (`id`),) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert into person(name, address) values ...

the column names are read from the xml, so are the values. If the for loop reads a column name that hasn't been created in the table yet, like "phone" it returns a sql exception "column name "phone" not found" and tries an alter table before inserting the values

alter table 'person' ADD COLUMN `phone` varchar(20) NULL default NULL;

here is where the program hangs. i've checked in mysql admin for the session and the state is "waiting for metadata lock" how can i pass this? or how do i remove the table metadata lock created by the previous insert which raised the exception. (the import is made in java that's why i use a for loop to parse the xml and get the element names and values) Thanks

I already saw that... hence the "which is obvious...". I was asking if there is any other solution to pass the pin code.

You're betting wrong. It does not matter how i install the service. I tried with Local System and with User but i get the same issue. Using the X509Certificate2UI throws exception: "The current session is not interactive"... which is kinda obvious Using the X509Certificate2 from file I get "Cannot create secure SSL/TLS channel" because it does not prompt me to enter the token pin number.

Hy, I have the following application: - server application that uses a digital certificate to login to a website; first time i run the app it requires the pin number from the token... certificate is stored on token); i use X509CertificateUI to select the certificate and it pops-up the token client to enter pin number; - client application connects to my server app and send some data which the server passes to the website to get response and send back to the client. Everything is working ok. BUT... i want to make it a windows service. (currently is form based). I have done the service part, i installed it, can start it from the service manager, but it doesn't show the certificate selection and the token client for the pin. here is the server code to get the certificate;

var store = new X509Store("MY", StoreLocation.CurrentUser);
store.Open(OpenFlags.ReadOnly | OpenFlags.OpenExistingOnly);

        X509Certificate2Collection selection = X509Certificate2UI.SelectFromCollection(store.Certificates,
                                                                                       "Digital Certificates",
                                                                                       "Select a certificate from the following list:",
                                                                                       X509SelectionFlag.
                                                                                           SingleSelection);

After i select it and enter the token pin number it works ok, but haven't been able to do the same as a windows service. I have also exported the certificate into a file from the token and declared a x509cert from local file but it should also require the token pin number.

X509Certificate2 localCert = new X509Certificate2(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\my.cer");
return localCert;

thanks

of course you can use the database.table.field syntax on mysql. the query i wrote works i only asked if someone has a better approach because the query gets difficult to follow once i use more databases and tables. The join operation joins tables on certain values. I don't need the joined. I just need to see where in those tables (the row id) a value is found.