Search Results

Search found 63598 results on 2544 pages for 'sql add on'.

Page 540/2544 | < Previous Page | 536 537 538 539 540 541 542 543 544 545 546 547  | Next Page >

  • C# Find out what column caused the Sql Exception

    - by PaN1C_Showt1Me
    Hi. I'm getting an exception from SQL Data Reader (MS SQL as datastore) and I'd like to know which column name causes this Exception to be thrown. But I cannot find it in the InnerException.. nowhere. ((System.InvalidOperationException)ex.InnerException).StackTrace: System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) System.Data.SqlClient.SqlDataReader.IsDBNull(Int32 i) ... Where is it hidden please ?

    Read the article

  • Pattern for creating a database schema using JDBC

    - by Space_C0wb0y
    I have a Java-application that loads data from a legacy file format into an SQLite-Database using JDBC. If the database file specified does not exist, it is supposed to create a new one. Currently the schema for the database is hardcoded in the application. I would much rather have it in a separate file as an SQL-Script, but apparently there is now easy way to execute an SQL-Script though JDBC. Is there any other way or a pattern to achieve something like this?

    Read the article

  • inserting large number of dates

    - by Radhe
    How can I insert all dates in an year(or more) in a table using sql My dates table has following structure dates(date1 date); Suppose I want to insert dates between "2009-01-01" to "2010-12-31" inclusive. Is there any sql query for the above?

    Read the article

  • Add methods to generated WCF client proxy code

    - by dcstraw
    I'd like to add one additional method for each service operation in my WCF client proxy code (i.e. the generated class that derives from ClientBase). I have written a Visual Studio extension that has an IOperationContractGenerationExtension implementation, but this interface only seems to expose the ability to modify the service interface, not the ClientBase-derived class. Is there any way to generate new methods in the proxy client class?

    Read the article

  • Developing Microsoft Outlook Add in From VSTO 2008

    - by kasunmit
    Hi team, I am going to develop outlook add in as my final year project. for that as a initial stage i need to develop a button in Outlook page after clicking that button system gets user's particular E-mail address (after clicking button the another window is open ans ask for mail address) and read unread E-mails from .pst file. pls help me to start my project by - developing particular button on Outlook, - then opening a particular window after clicking that button and - reading unread e-mail messages from .pst file. Thank you

    Read the article

  • adding checkbox to a combobox

    - by Radhe
    I want to add check boxes inside a combo box and then use the values of the checked boxes in my sql query. Also I need to append the checked values to an array and then use the elements of that array in my sql query. How can I proceed?

    Read the article

  • Update multiple table column values using single query

    - by Dave Jarvis
    How would you update data in multiple tables using a single query? In MySQL it would be: UPDATE party p LEFT JOIN party_name n ON p.party_id = n.party_id LEFT JOIN party_details d ON p.party_id = d.party_id LEFT JOIN incident_participant ip ON ip.party_id = p.party_id LEFT JOIN incident i ON ip.incident_id = i.incident_id SET p.employee_id = NULL, c.em_address = '[email protected]', c.ad_postal = 'x', n.first_name = 'x', n.last_name = 'x' WHERE i.confidential_dt IS NOT NULL What is the equivalent SQL statement using Oracle 11g? (Is ANSI SQL possible?) Thank you!

    Read the article

  • Add rel="xx" to jQuery a.link elements

    - by Xavier
    I use a little jQuery script to run a simple music player, but I'd like to add a rel="player" to the links in this jQuery script (the play/stop button for instance). This way I can exclude these rel="player" links from another jQuery script I use, because I don't want it to take the rel="player" elements into account. I reckon this is fair simple but i don't really know how to to it. Here is the jQuery script of the player, if it's ever necessary: http://hyker.be/cv/js/jquery.simpleplayer.min.js

    Read the article

  • mass add time in a file

    - by atinder
    i have a file in which time appears nearly hundred times like 00:01:32 00:01:33 00:01:36 ....................... how can i add 2 seconds or 2 minutes to all the times in the file so that i get 00:01:34 00:01:35 00:01:38 ..................

    Read the article

  • Add newlines to a text resource in Android?

    - by shmuelp
    I have a custom Dialog that contains only a TextView to display some text in my application. The documentation lists that only the b, i, u, tt, big, small, sup, sub, and strike tags are supported. I really need to add some newlines for readability. Do I need to change to a more complicated layout, or is there some way to encode newlines in the resource? I tried adding br tags, but that did not help.

    Read the article

  • mysql syntax error for timestamp

    - by eyecreate
    I have this piece of SQL that is being fed to Mysql. CREATE TABLE pn_history( member INT, action INT, with INT, timestamp DATETIME, details VARCHAR(256) ) But is comes back as an error about the syntax. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'with INT, timestamp DATETIME, details VARCHAR(256) )' at line 4 Why is this failing?

    Read the article

  • Add 'x' 30 mins blocks to time string (javascript)

    - by Mikey1980
    I have a 24 hour time string (ie 16:30) and would like to add x time blocks of 30 mins. For example if x = 4, then 16:30 + 4(30) = 18:30. Is there any easy way to do this with out exploding the string and doing if statements for mins/hours.. etc? Also this is on a php page would it be easier to do this in php then echo it to the javascript? Thanks for the help!

    Read the article

  • add space to every word's end in a string in C

    - by hlx98007
    Here I have a string: *line = "123 567 890 "; with 2 spaces at the end. I wish to add those 2 spaces to 3's end and 7's end to make it like this: "123 567 890" I was trying to achieve the following steps: parse the string into words by words list (array of strings). From upstream function I will get values of variables word_count, *line and remain. concatenate them with a space at the end. add space distributively, with left to right priority, so when a fair division cannot be done, the second to last word's end will have (no. of spaces) spaces, the previous ones will get (spaces + 1) spaces. concatenate everything together to make it a new *line. Here is a part of my faulty code: int add_space(char *line, int remain, int word_count) { if (remain == 0.0) return 0; // Don't need to operate. int ret; char arr[word_count][line_width]; memset(arr, 0, word_count * line_width * sizeof(char)); char *blank = calloc(line_width, sizeof(char)); if (blank == NULL) { fprintf(stderr, "calloc for arr error!\n"); return -1; } for (int i = 0; i < word_count; i++) { ret = sscanf(line, "%s", arr[i]); // gdb shows somehow it won't read in. if (ret != 1) { fprintf(stderr, "Error occured!\n"); return -1; } arr[i] = strcat(arr[i], " "); // won't compile. } size_t spaces = remain / (word_count * 1.0); memset(blank, ' ', spaces + 1); for (int i = 0; i < word_count - 1; i++) { arr[0] = strcat(arr[i], blank); // won't compile. } memset(blank, ' ', spaces); arr[word_count-1] = strcat(arr[word_count-1], blank); for (int i = 1; i < word_count; i++) { arr[0] = strcat(arr[0], arr[i]); } free(blank); return 0; } It is not working, could you help me find the parts that do not work and fix them please? Thank you guys.

    Read the article

  • How to add a new custom resource to routes Rails 3

    - by Jeroen janssen
    How do I add a custom route for a new resource in the Rails 3 routes? I know how to do it for collections and members but this style doesn't seem to be working for new resources. Is this a bug or am I doing something wrong? So these work: collection do get :wish end member do get :wish end But this doesn't work: new do get :wish end

    Read the article

  • Python and ReportLab: add a string at the end of every page

    - by user608341
    Hi peoples, I'm building a pdf document with reportlab, using the Paragraph class: doc = SimpleDocTemplate(response, leftMargin=lateral_margin, rightMargin=lateral_margin, topMargin=top_bottom_margin, bottomMargin=top_bottom_margin) Document = [] Document.append(Paragraph("bla bla bla bla", my_style)) doc.build(Document) Now I want to add at the end of every page a string, how can I do that??

    Read the article

  • Does add() on LinkedBlockingQueue notify waiting threads?

    - by obvio171
    I have a consumer thread taking elements from a LinkedBlockingQueue, and I make it sleep manually when it's empty. I use peek() to see if the queue empty because I have to do stuff because sending the thread to sleep, and I do that with queue.wait(). So, when I'm in another thread and add()an element to the queue, does that automatically notify the thread that was wait()ing on the queue?

    Read the article

  • Add a parameter to a google maps geocoder funcion

    - by kree
    I want to create a geocoder function, which write the result to it's parameter. function geoCode(latlng,div) { gc.geocode({'latLng': latlng}, function (result, status) { if (status == google.maps.GeocoderStatus.OK) { new google.maps.Marker({ position: result[0].geometry.location, map: map }); jq(div).html(result[0].formatted_address); } }); How can I add the div parameter to the geocoder function? Any help would be appreciated.

    Read the article

< Previous Page | 536 537 538 539 540 541 542 543 544 545 546 547  | Next Page >