273 Topics
 | Hello Havent been here in a while but might as well give it a shot. I have several Apache Tomcat instances running on a Windows Server on different ports. They are all HTTP. The idea would be to (on the same server) install a IIS and use it a content …  |
| | First, it has been a LONG time since Ive been here. Good memories from when I was young. Anyways In a monitoring system I have, I had a plugin that remotely checked a SMB share and if the file hasnt been modified in 1 day, it should return a warning. …  |
| | Trying to get the last row inserted from a Excel sheet. The sheet is called clientes. I have id, name, description Since ID is auto incremental, I can sort by ID: My idea is: oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; but it does not …  |
| | Where is the section to post code snippets? |
| | I want to write out a DXF file with line arc and maybe spline. My issue is documentation; While I have looked at AutoCAD's site I feel that there isnt enough to say "here is a BMP of a circle. Lets take it and convert it using this code". Its … |
| | (Ubuntu Server) I have a folder full of files in pairs (one is a log, another is a DB backup) They are basically create/modified at the same time. I need a shell script that detects if the folder has more than 28 or 30 files (always will be a pair), …  |
| | Im doing some work with C# and AD and Im missing something right now that I cant seem to see. I want to get a description of a security group in Active Directory and use that in a tooltip. I have all the security groups but Im not sure how … |
| | I have the following: string oledbcmd = ""; string constr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Excel.xls;@Extended Properties='Excel 8.0;HDR=Yes;"; oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; OleDbCommand oconn = new OleDbCommand(oledbcmd, con); OleDbDataAdapter sda = new OleDbDataAdapter(oconn); DataTable data = new DataTable(); sda.Fill(data); It fails. What is wrong with … |
| | I have a mobile VPN client that I want to backup to. The problem is that it does not have a static IP to due it being L2TP/IPSec. Thats the bad news. The good news is that there wont be too many VPN clients (at most 10 if that) so … |
| | I'm looking for the best way to back cold backups of the email on my client's PC. Starting off with PowerShell, I would run this: Get-ChildItem -Path 'C:' -Filter '*.pst' -Recurse -ErrorAction SilentlyContinue | Select-Object -Expand Directory -Unique | Select-Object -Expand FullName To search where the email file is. I … |
| | I see most PowerShell questions being asked in Shell Scripting and its not really a scripting language per say as it is much deeper than that. I porpose it gets its own section...  |
| | Hey I was wondering how to generate a Windows popup in C. I mean by "Windows popup" as in (for example) when you do a net send message to a PC, a simple Windows popup comes up on the PC you sent the message to with the message. How can … |
| | I have several databases located over the world, this all have the same structure, with the same tables and triggers. For clarification purposes: Site 1: database_1 (with all its tables same as other sites) Site 2: database_1 (with all its tables same as other sites) Site 3: database_1 (with all … |
| | Hello I want to make a button autoclick itself. JQuery? Whats the best way? Tried trigger click but nothing Thanks |
| | I need a connector to connect from a application running on Windows CE machine to a MySQL Server. Is there anything like this for both ARM and x86? Thank you |
| | Hello Lets say I have a online store where I sell shirts. First I select a shirt (colored or design) after I can choose to draw something else or leave it as is. Later, standard regular checkout and buying process. How can I do this? What eCommence should I choose? … |
| | I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks  |
| | I have a table called "mytable". The columns are Time_Stamp (datetime) PK Time_stamp_ms (int) PK data1 (int) data2 (int) data3 (int) data4 (int) data5 (int) data6 (int) cycle (int) name (varstring) I want to order by Time_Stamp and Time_stamp_ms and then each time cycle reaches 1, I want to get … |
| | Im doing a query and Im getting this: Error Code: 3. Error writing file '/tmp/MYYQVeZr' (Errcode: 28) Its not a space issue or a permission issue either:  Whats wrong? |
| | Simple timediff: SELECT time_format(timediff('2014-04-24 09:11:37','2014-04-24 09:09:37'),'%H:%m:%s') as dif Returns 00:00:00 . Im problably missing something stupid, my apoligies... |
| | Im thinking of proper ways to validate dates. Which months have 30 or 31, feb when it has 28, etc. Since Im doing this in VBScript and there is no forum for that here, I thought of making this thread for a pseudocode method of doing it correctly universally. No … |
| | I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks |
| | I have in a MySQL database with the column type being DateTime the following time: Timestamp: 9:34:09 9:34:23 9:34:45 9:34:50 9:35:09 9:36:17 But a DataGridView in C# only shows me 9:34 9:34 9:34 9:34 9:35 9:36 Why? |
| | I insert something simple like insert into table(pri1,pri2,value) values (1,1,1); insert into table(pri1,pri2,value) values (1,2,1); And in MySQL 5.6 they show up as: pri1 pri2 value 1 1 1 1 2 1 BUT In MySQL 5.1 I do the same thing and they show up as: pri1 pri2 value 1 … |
| | Hello Sometimes I get a duplicate key which I want to ignore or discard. This is a example and has nothing to do with the actual query. I simple want to state columns/values insert into table(Time_Stamp,Time_Stamp_ms,p1) values (time,timems,'1') Where the first two are my PK. I see that insert into … |
| | I have this table: Time_Stamp Time_Stamp_ms '2014-04-11 13:33:24', '879', '5555', '4444', '3333', '2222', '1111', '123', '1', 'text' '2014-04-11 13:33:24', '899', '5555', '4444', '3333', '2222', '1111', '123', '2', 'text' '2014-04-11 13:33:24', '919', '5555', '4444', '3333', '2222', '1111', '123', '3', 'text' '2014-04-11 13:33:24', '939', '5555', '4444', '3333', '2222', '1111', '123', '4', 'text' … |
| | I would like to be able to store data in various files instead of one huge one to make remote backups easier on MySQL. How can I set this up? Thank you |
| | We have various databases on several offsite locations and we want to do a backup to here. Problem is that database is problably going to weigh GBs of data so it would be better to split it into several "files" so we can only get the updates in small amounts. … |
| | I want to get a string in hex (example: "07DE" is 2014) and convert that to a char. How can I do this in MySQL Server? Sorry for the sloppy explanation Thank you  |
| | I have pairs of hex digits that I want to convert to char. What is the best way to do it? Thank you |
| | In MySQL server, I want to do a trigger that checks when a row inserted, if the row has the previous value in column A than the previous row, it should delete it. Im a little forgetful on how to check this correctly so if someone could lend a hand, … |
| | I store "BYTE[]" type data into a BLOB. It stores it perfectly, the data being represented by hexadecimal pairs when I try to view it in MySQL. Now I want to convert that hexadecimal pairs into string. All the data is "simple" data such as strsing, intesger, floats, e the … |
| | I recently upgraded MySQL 5.5 to 5.6 because I needed some features but now Im not sure which my.cnf 5.6 loads... I try editing the my.cnf in /etc with some lines such as "port=hello" but it still loads and starts correctly. How can I see the exact route of the …  |
| | We plan to record/read data as fast as 10 ms (that's milliseconds) to a database. Now, this database will be in a factory so there is gonna be a lot of vibrations, temps, etc... Logically the first choice to everyone is a SSD. The problem with the SSD is that … |
| | I want to prepare MySQL Server 5.6 for thousands/millions of inserts. Ive found this: •innodb_doublewrite = 0 •innodb_buffer_pool_size = 50%+ system memory •innodb_log_file_size = 512M •log-bin = 0 •innodb_support_xa = 0 •innodb_flush_log_at_trx_commit = 0 Is there anything else I can do? Thank you |
| | I want to store my databases only on RAM. I see that in MySQL server I can choose the "MEMORY" engine and the table with be stored only in the RAM. How about MS SQL Server? How can that be done there? Thank you  |
| | Oldest question in the book. Google says: SELECT NOW()+ 0; And a bunch of other things like UNIX_TIMESTAMP() but doing a select on these, it only returns the seconds, not including the miliseconds. Basically, I need, from MySQL's side the milliseconds. How can I do this? |
| | Why is making a thread (typing it out allowed) and then if I forget to login, it takes me to another page making me lose the entire typing? Login should be required first before making a thread. Or at least make it AJAXy  |
| | Im trying to make a email form where people can visit our site and send us emails. Since I am not sure if I can add PHP code, lets stick to JS and HTML. I believe I can add JS libraries: Basically: Introduce your email address Dropdown box that you …  |
| | Just a quick lookout: Still says 2013 at the bottom.  |
| | Hey I want to make a backup and restore of a MySQL **SERVER** to another machine. Please note the **SERVER** part; I want to backup/restore datebases, tables, procedures, users, configuration, etc....**EVERYTHING** What is the best way to do this? Thank you |
| | Hey I want to get a (free) SSL certificate so I can test it out (on localhost) before applying it on my real site. This is for a Magento store but should be universal, more or less. Resources? Where should I get it from? How to? |
| | Hello, We uploaded some videos in the back to YouTube and they reproduce perfectly on our webpage. The thing is, with mobile becoming more and more intresting, playing them in a HTML5 video player would be more universal. How can we make this change? |
| | Hello How can I do something like this: <script type="text/javascript"> var one="hi "; var three="there"; <?php echo ConcatTwoStrings(?>one<?php,?>two<?php);?>; </script> That should produce "Hi there". Yes, I know there is concat Javascript functions; Thats not the point as I was simply showing a easy example. How can I do the above? …  |
| | Hello I want to have a drop down menu showing small thumbnail pictures and text in a "smartphone like" grid. What can I use to accomplish this? Thank you |
| | I have a table (employees) like this ID Name Group Email 1 Bob Buckland Marketing b@example.com 2 George Alaz Engineering g@example.com 3 Tom Grady Marketing t@example.com 4 Mary Jane Engineering m@example.com Im going to use this in a email form. First a combobox should load all the groups possible. This … |
| | Hello I want to add fields in the checkout page that my customer can directly add his credit card details, charge him and make the checkout complete all in the same page. How can I do this? Ive seen it on other pages. Thank you |
| | stupidajax: function() { var varpas=$j('#somediv',window.parent.document).text(); varpas.replace(/\s/g, ""); $j.ajax({ // Start AJAX function url: 'mysqlcall.php', //script async: false, data: "parameter1="+varpas, //you can insert url argumnets here to pass to api.php //for example "id=5&parent=6" dataType: 'json', //data format success: function(data) //on recieve of reply { //start success function var selecthtml='Things: <select name="d" … |
| | Hello Im looking for a jQuery Easy Slider type of plugin but instead of images, allows me to present HTML/JS/etc content to the user for when he, for example, click on the next button (something that Easy Slider provides) Anything like this out there? |
| | Before people start flaming me for the title I want to make it perfectly clear that MOST members are very helpful and somewhat polite. They have a lot of knowledge and help out when they can. My problem is with the posting system. I am registered to nearly 50 forums … |
The End.