222 Archived Topics
Remove Filter  | 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 … |
| | 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... |
| | 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  |
| | 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 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? |
| | 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 …  |
| | 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?  |
| | Hello http://www.hotel-oxford.ro/en I am VERY intrested in making a webpage like this, with one page only showing and when I click a button it goes to the next page (or scroll, however you want to call it). What plugin is used here? Thank you |
| | Hello I want to make a standalone program that (for example) is for a very small supermarket that stores in a database their stock. Now, I dont think it is neccesary to install MySQL Server on a client's computer so how do you "embed" it so to speak into the … |
| | Hello I want to create a Javascript button that takes a image on a page and makes it bigger keeping aspect ratio and also another button and makes it smaller but also keeping aspect ratio. Can someone tell me a good example on how to do this? Thank you  |
| | Hello I have this similar code: var SomeVar = Class.create({ one: null, two: null, three: null, initialize: function(one, two) { this.one = one; this.two = two; }, startListeners: function() { $j('#somediv1').mousedown(function(e) { this.three=3; three="hi" }.bind(this)); $j('#somediv2').mousedown(function(e) { console.log(this.three); console.log(three); }.bind(this)); }, }); As you see there are more can one … |
| | Hello This is one of those stupid questions but you gotta ask to be sure What is var h=0; h += 5; var l=0; l -= 5; Is it the same as: var h=0; h = h+ 5; var l=0; l = l- 5; Thanks and sorry for the stupidity  |
| | I currently have $tableName="thenameofthetable"; $someid=$_GET["someidthruget"]; $result = mysql_query("SELECT name,age FROM ". $tableName. " WHERE idp=". $someid); Which looks really insecure. How can I do it using a stored procedure which I think will make it a lot more secure? Thanks |
| | Hello For some odd reason, I have a picture with a link and it shows in all browsers except IE8/9/10. What can I use to debug the problem? |
The End.