Is there any handy tool that can make updating tables easier? Usually I got an Excel file with the original value in one column and new value in another column. Then I write a formula in Excel to create the 'update' statement. Is there any way to simplify the updating task?
I believe the approach in SQL server 2000 and 2005 would be different, so could we discuss them both? Thanks.
I'd like to write a test script or program that asserts that all dlls in a given directory are of a particular build type.
I would use this as a sanity check at the end of a build process on an sdk to make sure that the 64bit version hasn't somehow got some 32bit dlls in it and vice versa.
Is there an easy way to look at a dll file and determine its type?
The solution should work on both xp32 and xp64.
Hi, i would like to create a Rails controller that download a serie of jpg files from the web and directly write them into database as binary
(I am not trying to do an upload form)
Any clue on the way to do that ?
Thank you
I want show an information page after success db opartions. And after the info I want to close each pages (information page and main page)
I wrote this in button oncommand event:
//but this code does not work
Response.Write("<script language='javascript'>setTimeout('self.close();',3000);</script>");
at the same time, I want to show an information message. And then I want to close all, after three seconds.I hope I could explain :)
Thanks.
Hello, I have recently started to develop applications for iPhone with MonoTouch and have to store user names and passwords on the phone. I want to use the keychain for this but can't find anything in the MonoTouch documentation about it. Is it possible to use it directly with MonoTouch or will I have to write some C++/C/Objective-C code that uses the keychain and export it to MonoTouch?
Ey guys, I have been searching for some sample code on how to store an NSArray in Core Data for awhile now, but haven't had any luck. Would anyone mind pointing me to some tutorial or example, or better yet write a simple sample as an answer to this question? I have read this but it doesn't show an example of how to go about implementing a transformable attribute that is an NSArray. Thanks in advance!
I'll admit I'm a novice programmer and really the only experience I have is in classic ASP. I'm looking for a way to convert this asp code to PHP. For a customer who only has access to a linux box but also as a learning tool for me.
Thanks in advance for the help:
Recordset and Function:
Function pd(n, totalDigits)
if totalDigits > len(n) then
pd = String(totalDigits-len(n),"0") & n
else
pd = n
end if
End Function
'declare the variables
Dim Connection
Dim Recordset
Dim SQL
Dim SQLDate
SQLDate = Year(Date)& "-" & pd(Month(Date()),2)& "-" & pd(Day(Date()),2)
'declare the SQL statement that will query the database
SQL = "SELECT * FROM tblXYZ WHERE element_8 = 2 AND element_9 > '" & SQLDate &"'"
'create an instance of the ADO connection and recordset objects
Set Connection = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")
'open the connection to the database
Connection.Open "PROVIDER=MSDASQL;DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;UID=xxxxx;PWD=xxxxx;database=xxxxx;Option=3;"
'Open the recordset object executing the SQL statement and return records
Recordset.Open SQL,Connection
Display page/loop:
Dim counter
counter = 0
While Not Recordset.EOF
counter = counter + 1
response.write("<div><td width='200' valign='top' align='center'><a href='" & Recordset("element_6") & "' style='text-decoration: none;'><div id='ad_header'>" & Recordset("element_3") & "</div><div id='store_name' valign='bottom'>" & Recordset("element_5") & "</div><img id='photo-small-img' src='http://xyz.com/files/" & Recordset("element_7") & "' /><br /><div id='ad_details'>"& Recordset("element_4") & "</div></a></td></div>")
Recordset.MoveNext
If counter = 3 Then
Response.Write("</tr><tr>")
counter = 0
End If
Wend
Hello,
I have written the Dijkstra's algorithm many times in C++ - I need there set or priotity_queue, both give me possibility to add an element and find the least one (using specified comparator). Now, I've got a problem when trying to write Dijkstra in C# - is there any structure which could be useful for me? I need adding and finding or erasing the least element.
Using Visual Studio '08
I'm trying to figure out if
g++ -fsyntax-only
does only syntax checking or if it expands templates too.
Thus, I ask stack overflow for help:
is there to write a program so that syntactically it's valid, but when template expansion is done, an error occurs?
Thanks!
I am trying to write an app for Toontown that will send the "end" key when the application is minimized or hidden. How do I do this. I cant figure it out
Thanks
I'm writing a C++ app.
I have a class variable that more than one thread is writing to.
In C++, anything that can be modified without the compiler "realizing" that it's being changed needs to be marked volatile right? So if my code is multi threaded, and one thread may write to a var while another reads from it, do I need to mark the var volaltile?
[I don't have a race condition since I'm relying on writes to ints being atomic]
Thanks!
Hi,
I was wondering if it is possible to make a "link" in usr/bin (i.e.) that leads to a shell-script.
But I want just to write
% shellscript
instead of
% sh shellscript.sh
kinda like an alias.
Is this possible?
Hi,
I have a method which handles a set of records.This method,return true\false after processing.So,if all the records are processed(doing some db updates),will return true.Now,suppose after processing 1 record,some exception is thrown,should I write result=false(at the end of method result is returned) in catch block? And,allow processing of other records to be done?
In Asp.net (c#),i'm not able to catch exception(FileNotFoundException) properly... i don't know the reason..Actually File s not there..But catch statement fails to catch the exception..
here is the code..
try
{
System.Drawing.Image imgg1 = System.Drawing.Image.FromFile(Server.MapPath("").ToString() + "\\images\\img1.jpg");
}
catch (FileNotFoundException)
{
Response.Write("<script>alert('Please Select and upload Student's Photo');</script>");
}
I have a DataGridView which is filling from Table in SQL Server Database. One of it's columns is "price".
Type of column in DGV is automatically sets as Decimal.
In some cases I need to write in cells of this column text like "none", instead of price.
How can I do it?
DGV.Item("price", 0).Value = "none"
doesn't work, because of decimal type of a cell.
I need to write a daemon that supposed to have one TCP socket and one named pipe. Usually if I need to implement a multi IO server with "pure" sockets, the select based multi-IO model is always the one I will choose. so does anyone of you have ever used named pipe in select or you
can just tell me it is impossible. thanks in advance.
I want to be able to do logging in every catch block. Something like this.
catch (Exception exception)
{
Logger.Write(exception);
}
and then the settings in the configuration will pick up the Message and StackTrace property etc using customer listener.
I would like to use Enterprise Library Logging Application Block. I'm sure someone must have done this already.
Modern keyboards have special multimedia keys, e.g. 'Pause/Play' or 'Open Web Browser'. Is it possible to write a program that "presses" these keys?
I would prefer solution in C, but I would accept a language agnostic solution, too.
According to the selectors docs, you must escape [ with double backslash, etc \\[.
I have a selector that is created like so (assume val attribute is something[4][2] in this example).
var val = $(this).attr('val');
$select.find('option[value=' + val + ']').show();
Can I write a regex to escape the brackets for me?
in a double-submitted cookie csrf prevention scheme, is it necessary for the server to provide the cookie?
it seems i could have javascript on the clients page generate and set a cookie "anti_csrf", then double submit that (once as a cookie, done by the browser, and once in the body of the request).
a foreign domain would not be able to read or write the "anti_csrf" cookie to include it in the body of a request.
is this secure, or am i overlooking something?
I HAVE TO RETRIEVE ID AND LAST_NAME FROM MY TABLE BUT THE THING IS THAT MY ID IS NOT CONTINUOUS AND THERE NO PATTERN FOR THE GAPS. NOW I WANT TO WRITE A PL/SQL ANONYMOUS BLOCK FOR THIS.
Some time ago I had a look into Ruby and one of the things which stood out most for me was the way of using symbols.
While you to use defines or strings like in C++ or Python as an alternative, in Ruby you just write :mySymbol and the interpreter takes over the enumeration for you.
I can't see any disadvantage this feature has, so why is it missing in say, PHP and Python?
I have a table like this
C1 C2 C3 Code
1 2 3 33
1 2 3 34
2 4 1 14
1 2 3 14
i want to select only those record whose code is appearing only in single row. ie, in this case rows with code 33 and 34.. as they appear only once in this table.
How can i write a query for that