Posts
 
Reputation
Joined
Last Seen
Ranked #489
Strength to Increase Rep
+9
Strength to Decrease Rep
-2
64% Quality Score
Upvotes Received
125
Posts with Upvotes
75
Upvoting Members
33
Downvotes Received
68
Posts with Downvotes
37
Downvoting Members
25
20 Commented Posts
~370.60K People Reached
About Me

Programmer that hates programming

Favorite Tags

356 Posted Topics

Member Avatar for riahc3

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 …

Member Avatar for blud
2
42
Member Avatar for zamurai127

I disagree. Way too powerful if you want something simple. If you 200% control PHP/JS/HTML, then Magento may be for you.

Member Avatar for anastefanyuk
0
295
Member Avatar for riahc3

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. …

Member Avatar for Dani
0
91
Member Avatar for Devid Billa

You said you need a website with "chat,downloads,messages ect.". I think before even creating your site, you need to know what is your website going to transmit and who is your target audience. Another thing: There are web programmers and web designers. VERY RARELY, one person is good at both. …

Member Avatar for ivy.inc.Hugh
-2
2K
Member Avatar for riahc3

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 …

Member Avatar for rogerwigaa
0
1K
Member Avatar for caitlyndania
Member Avatar for riahc3
Member Avatar for riahc3

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 …

Member Avatar for ez4u2c
0
2K
Member Avatar for riahc3

(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), …

Member Avatar for rproffitt
0
515
Member Avatar for riahc3

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 …

Member Avatar for rproffitt
0
290
Member Avatar for rajesanthu
Member Avatar for nate_2
0
137K
Member Avatar for riahc3

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 …

Member Avatar for riahc3
0
297
Member Avatar for riahc3

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 …

Member Avatar for Kayasax
0
365
Member Avatar for riahc3

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 …

Member Avatar for Kayasax
0
502
Member Avatar for riahc3

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...

Member Avatar for pritaeas
0
314
Member Avatar for riahc3

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 …

Member Avatar for tirumalai
0
9K
Member Avatar for riahc3

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 …

Member Avatar for riahc3
0
466
Member Avatar for riahc3

Hello I want to make a button autoclick itself. JQuery? Whats the best way? Tried trigger click but nothing Thanks

Member Avatar for shophiarajan47
0
195
Member Avatar for riahc3

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

Member Avatar for riahc3
0
1K
Member Avatar for alyssa.wilkins.77

Programming generally sucks. Period. Web programming, although it sucks even more, gets better paid. Do note that you have to know A LOT more languages: PHP, JS, HTML, Flash (yes, Flash), etc with others.

Member Avatar for Mya:)
0
372
Member Avatar for MasterHacker110

Id take a hack at it (putting it on my PC and testing it) but is this Pascal or Delphi? Looks like Delphi...

Member Avatar for Mya:)
0
6K
Member Avatar for riahc3

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? …

Member Avatar for oCodewire
0
250
Member Avatar for riahc3

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

Member Avatar for Kyle Wiering
0
305
Member Avatar for riahc3

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 …

Member Avatar for diafol
0
395
Member Avatar for riahc3

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: ![55777bcf7c6e92ac68de57e1f4b594f0](/attachments/large/1/55777bcf7c6e92ac68de57e1f4b594f0.png "55777bcf7c6e92ac68de57e1f4b594f0") Whats wrong?

0
243
Member Avatar for riahc3

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...

Member Avatar for riahc3
0
190
Member Avatar for riahc3

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 …

0
90
Member Avatar for riahc3

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

Member Avatar for diafol
0
264
Member Avatar for riahc3

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?

Member Avatar for riahc3
0
1K
Member Avatar for riahc3

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 …

Member Avatar for riahc3
0
487
Member Avatar for riahc3

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 …

Member Avatar for riahc3
0
184
Member Avatar for jaejoong
Member Avatar for riahc3

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' …

Member Avatar for riahc3
0
220
Member Avatar for riahc3

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

Member Avatar for riahc3
0
274
Member Avatar for riahc3

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. …

Member Avatar for riahc3
0
372
Member Avatar for riahc3

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

Member Avatar for Alberto Bucur
0
103
Member Avatar for riahc3

I have pairs of hex digits that I want to convert to char. What is the best way to do it? Thank you

Member Avatar for riahc3
0
95
Member Avatar for riahc3

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, …

Member Avatar for riahc3
0
170
Member Avatar for riahc3

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 …

Member Avatar for riahc3
0
234
Member Avatar for riahc3

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 …

Member Avatar for rch1231
0
232
Member Avatar for riahc3

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 …

Member Avatar for riahc3
0
265
Member Avatar for riahc3

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

0
92
Member Avatar for riahc3

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

Member Avatar for Reverend Jim
0
426
Member Avatar for riahc3

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?

Member Avatar for riahc3
0
3K
Member Avatar for Dani
Member Avatar for riahc3

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

Member Avatar for ahqaf
0
190
Member Avatar for riahc3

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 …

Member Avatar for patk570
0
190
Member Avatar for riahc3
Member Avatar for riahc3

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

Member Avatar for Manish02
0
236
Member Avatar for Graphix

He was obviously being sarcastic.... > Due to the fact it is not possible (in web apllications) to open a words file using Java, it is required to directly put the words string separated by a | into the string variable. Modify the string in the initGame() function in the …

Member Avatar for JamesCherrill
2
4K

The End.