Posts

c# - Microsoft word document to OLE field -

Image
I am trying to upload the docx document to access the database. OleDbConnection conn = null; OleDbDataReader Reader = Faucet; Try {Conn = new OleDbConnection ("Provider = Microsoft.ACE.OLEDB.12.0;" + "Data Source =" + "" @: "C: \ Audios \ Auditor_Artificci 20077.ACADB"); Conn.Open (); Olebey Commands CMD = New Oleadby Commands (); Cmd.CommandText = "Questions (Category, Question, Answer, Correct Answer, Comment, Reference, Question No, Change, Issue) Prices (@ P2, @ P3, @ P4, @ P5, @ P6, @ P7, P in P8, @ P9, @ P10) "; Byte [] file = file. Read AllBytes (@ "C: \ AudSystem \ rez.docx"); Cmd.Parameters.AddWithValue ("@ P2", 2); Cmd.Parameters.AddWithValue ("@ P3", file); Cmd.Parameters.AddWithValue ("@ P4", file); Cmd.Parameters.AddWithValue ("@ P5", "AD"); Cmd.Parameters.AddWithValue ("@ P6", "FH"); Cmd.Parameters.AddWithValue ("@ p7", "z...

php - Wrap array around SimpleXML object -

I get XML results from a web service, which I read as simple XML elements. Now there is a situation that results can vary depending on the configuration given by the web service. The issue is: I want to wrap an array around ordinary XML objects in "position 2", so I do not later "simplify XXXXXXconfig inside the array" and "Surfag" while processing the data. Configure the form as "the difference between the object. I have been looking for a while for a while and thinking, but by now I could not find anything. Situation 1: Many simple xx elements are returned within an array ["myConfig"] = & gt; Array (2) {[0] = & gt; Object (simple assemment) # 41 (5) {["id"] = & gt; String (1) "1" ["type"] = & gt; String (1) "4" ["Comment"] = & gt; String (2) "Fobor" ["name"] = & gt; String (1) "Exam" ["attribute"] = & gt; String (5...

reporting services - Need To Calculate Percentage Difference In ssrs with multiple row and column Grouping -

I have a line and column grouping. I need the difference and percentage difference of each month as shown below. Example: march diff 2013 2014 Hyderabad 12 15 15-12 = 3 I want more than this result, I need percentage difference ---- (this year - last year) / last year I usually try to handle it in SQL and dumb report. In your case, I look at the result like this: City month month month year Dravid year's feed --------- ---- --- --- ---------------------- Hyderabad 3 March 2013 2013 12 Hyderabad 3 March 2014 2014 15 Hyderabad 3 March 99 99 Diff 3 Hyderabad 3 March 99 99% Diff 0.25 Your Row group will be the city. Your column group 1 group / sorting will be on the monthly integer, and the month displays the string. Your column group will group / sort 2 years / fid integer, and the eardid string will display. If you provide your SQL, then I can help the result look like this. If you insist on computing on this report and you have a city, date and value fie...

uislider - In a MATLAB GUI, how does one implement a continuously varying slider from a GUIDE created .m file? -

I am trying to create a GUI with a plot and a slider. The slider should be described as continuously and output. I have a problem with this explanation that the uicontrol object is programmatically created, on the contrary, I want to know that in the last three instances, to complete the same thing done according to the program What can be added to a GUI file that is created. The code is down, and I have marked the (wrong) code that is provided by some of the above examples. Thanks a lot for any help! This slider function sets P1_slider_Callback (hObject, eventdata, handle) (handle, dragon, 'string', num2str (get (hObject, 'value'), 3)) PlottheData_Callback ( HOBject, EventData, Handle)% "PlotHeadata" is a button that creates the data slider based on the value of P1_slider%, and I think that here "p1_slider_CreateFcn" (hObject, eventdata, handle) needs to be assembled (HOBJECT, 'BackgroundRoller'), (0, 'Default UITTACKBACK MANDROLLE...

jQuery Dialog Chrome issue -

I am using a jQuery dialog box. I'm facing a problem in Chrome browser $ ("# dialog"). App ('& lt; p class = "elms"> This step 1 & # 39; & # 39;); I have written the JS code in I where I am adding new material to the dialog box that was opened. But I have an AJAX request after the ADX statement. jQuery.ajax ({type: "post", datatype: "Jason", .... What is this on Chrome that the dialog The box does not say "this step 1 message." But it only displays the end result by jquery.ajax. "This is step 1 message" in the Firefox browser. After this the result has been returned with the jquery.ajax call. How do I fix this problem? Remember .dialog (); $ ("# dialog"). Attachments ('& lt; p class = "elm" & Gt; this step 1 & lt; / p & gt; '); $ ("# dialog"). Dialog (); If it does not work for you, Try: $ ("# dialog"). E...

How to run SQL(MYSQL) stored procedure in JAVA jdbc? -

I am a MySQL user and I am using the following statement in the MySQL workspace: (Based on these statements) / P> SET group_concat_max_len = 4294967295; SELECT GROUP_CONCAT ('SELECT', QUOTE (COLUMN_NAME), 'FROM (choose * from table_name * s3_01 =', coloumn1, '' 'abc', 'WHERE', REPLACE (COLUMN_NAME, '`', '` `') Not Faucet, 'Hosting COUNT (*)' SEPARATOR Union All ') Information from INTO @sql_SCAMA Columns where TabCHAMA = Database () and Tableinda = 'Table_Name'; Prepare SSML with SSMT; EXTUTE STMT; DEALLOCATE STMT; Although it works in my workspace, I do not know how it works in Java. For example, I created the following code: string sql1 = "SET group_concat_max_len = 4294967295;"; String sql2 = "SELECT GROUP_CONCAT ('SELECT', QUOTE (COLUMN_NAME), 'FROM (select * from PTC_weight) where S3_01 =', column 1, '' ABC '', 'WHERE', repeat (COLUMN_NA...

c# - Polling the right way? -

I'm software / hardware engineer with some experience in C and embedded technologies, and currently I'm doing something in C # (.NET) I'm busy writing apps which are using hardware for data acquisition. Now the following, burning for me, question: For example: I have a machine in which there is one end to find the last place of a pivot. Now I am using the USB Data Acquisition module to read data. Currently I am using a thread to read port-states continuously. There is no interruption on this device. My question: Is this the right way? Should I Use Timers, Threads or Tasks? I know that there is something in the poll that most of you "hate", but any suggestions are welcome! IMO It depends very heavily on your exact environment, but before that: in most cases you have threads Should not be used Low voting interval: Timer and voting in tick . Work Medium: Waiting for Tasks and Tasks Delay (delay) High: Using tasks and threads. Sleep (delay)...

javascript - Testing selector presence in Jasmine -

Do anyone know how I can test it in Jasmine? function gameWon) {$ ('#final_message_cpu'). Html ('you von !!!') $ ('. Computer_selection'). CSS ('display', 'block'); Deleting $ ('# Show_after_starting'). $ ('# Hide_after_starting') CSS ('display', 'inline') $ ('# hide_after_starting'). Click (function () {location.reload ();}}} What is the only way I can test to see if $ ('# show_after_starting') is deleted has given? Yes: expected ($ ('# show_after_starting') Length). TBE (0);

sql - Speed up very slow query -

I am trying to delete the old records from the old SQLite3 database to 30,000 old records. I'm using this question to remove: remove items from items ITEMS_ID IN (SELECT ITEMS_ID) with objects where the last time is not like '2014%' And do not like '2013%' and finally '2012%' and ITEMS_ID! = 1 and ITEMS_ID! = 4); The problem is that I have seen that this query is very slow or better, it is so slow that it takes ages and I have to stop it because it seems stuck. I think the problem is that IN () within SELECT statement is being repeated for each row repeated How can I fix this query? Before heavy deletion, make sure there are no triggers behind the curtains, which are delete statement can be quite slow. I do not think it is possible to temporarily disable triggers in SQLite because it is in other DBMSs. Therefore, you have to do this: Delete Trigger Script Drop Dump Triggers Run Delete Question Rebuild the trigger to be removed ...

javascript - Laravel PHP Jquery - TextBox updating Label -

मेरे पास यह टेक्स्टबॉक्स है {{form :: text ('horasT', $ HorasT, array ('class' = & gt; 'इनपुट-ब्लॉक-स्तरीय', 'प्लेसहोल्डर' = & gt; '0.00'))}} मैं एक लेबल को अपडेट करना चाहता हूं जब टेक्स्ट बॉक्स वैल्यू परिवर्तन। यह लेबल है: & lt; लेबल आईडी = "उप-कुल" नाम = "उप-कुल" & gt; 0 & lt; / label & gt; मेरी जेक्जरी यह है: jQuery ('# horasT')। पर ('इनपुट', फ़ंक्शन () {var valT = $ (' #horasT ')। Val (); $ (' # subTotal ')। Value = valT;}); यह काम करने के लिए प्रतीत नहीं होता है और मैंने अब तक कई चीजों की कोशिश की है। लेकिन मेरे लिए यह काम करना चाहिए ... क्या लगता है समस्या? लेबल केवल 0 में बैठता है कोई भी बात नहीं है जो टेक्स्ट बॉक्स में है इवेंट है और लेबल में पाठ नहीं है संभावित अन्य ईवेंट को ट्रिगर करने के लिए: "इनपुट परिवर्तन कीप कीप कट पेस्ट माउसउप फोकस ब्लर" & lt; script src =" https : //ajax.googleapis.com/ajax/lib...

php - how could we find the page URLs which is not linked to any menu in drupal 6? -

How can we find page URLs that are not associated with any menu item or are stand-alone pages in Drupal 6? The suggestion of any question is also correct ... Something like this: Select 'menu_links' from the select * menu, where select 'menu_links', select menu_name = 'navigation' link_path)

Converting wgs84 POINT into Coordinate LON, LAT -

मेरे पास wgs84 बिंदु की यह परिभाषा है: enforce_geotype_coordinate_wgs ((ज्यामितीय टाइप (coordinate_wgs84) = 'POINT' :: पाठ) enforce_dims_coordinate_wgs84 (st_ndims (coordinate_wgs84) = 3) enforce_srid_coordinate_wgs84 (srid (coordinate_wgs84) = (-1)) " ऐसा लगता है: " 0101000000315601E572722F40842D615AA089444 " / P> मुझे पोस्टजीआईएस के कार्य को नहीं पता है जो इस बिंदु को जीडी (अक्षांश, रेखांश) [जीपीएस] समन्वय में बदल देता है। क्या आप मेरी मदद कर सकते हैं। धन्यवाद सरल उपयोग: ST_X ("coordinate_wgs84") एक्स के रूप में, ST_Y ("coordinate_wgs84") वाई के रूप में।

jquery - The right way to include page specific Javascript in Rails -

I want to include it, for example: jQuery. Ready (function ($) {$ ('# my-modal'). Modal (option)}); In my case in a specific place in a Rail App file / model / mymodal.html. Called ARB. There and only there. I do not understand that if I put it in the property then why not do it with all the pages, thanks so much! These are some useful moves # 1 file js Remove // require_tree. application.js at your.js for code-per compound add code on Config / application.rb >: config.assets.precompile + =% w (your.js) # 2 inserted non-layout in specific file (not recommended) mymodal.html. ARB Put your JS script with javascript tag on # 3 .. this .. Change your code to layout / yourlayout.html. Enter in ARB and use if ..and .. argument example: & if; Current_page? (Yourspecific_path)%> & Lt; Script language = "text / javascript" & gt; Your javascript is here .. & lt; / Script & gt; & Lt;% en...

python multiprocessing with map_sync - catching problems -

I am trying to use a multiprocessing package in Python. I have a code that is designed to generate output based on the collection processes that have many processors ... years = [2013] days = [1,2,3,4,5,6,7,8,9, 10] months = [8] hours = [0, 6, 12, 18] ens = [1, 2, 3, 4] nuns = Lane (days) * lane (hours) hours = hours * lane (days) year = days * days (days) * lane (hours) month = months * lane (days) * lane (hours) temporarily = [days] D: temp.append ([d] * lane (hour)) = [x in the sublist for x in the sublist for hours] hour = hour * lane (d N) nens = ens * len (day) In this example I have 260 times that are near different processors. t1 = c [:]. Map_sync (doCoolStuff, year, month, day, hour, nanus, [option] * lane (day)) There are times when there is a missing / incomplete data When this happens, then kills all the processes on other nodes. Is there any way to catch these examples? I'm not sure / works here except for try. Thanks I can think of two options...

python - create heatmap2d from txt file -

Image
I have set 2D data (30a) as a set txt file. XY 2.50 135.89 2.50 140.92 2.50 157.53 2.50 114.61 2.50 119.53 2.50 154.14 2.50 136.48 2.51 176.85 2.51 147.19 2.51 115.59 2.51 144.57 2.51 148.34 2.51 136.73 2.51 118.89 2.51 145.73 2.51 131.43 2.51 118.17 2.51 149.68 2.51 132.33 I plotted with Gnuplot as a scatter plot but I would like to represent a heatmap as a 2D or density distribution. I saw examples in MatPlotLib or R and they have already started with random data to generate all the images. I tried those codes and got an error like this hist, edges = histogad ([x, y], cans, range, honorary, weight) Attribute: Error: The compartment's dimensions should be equal to the dimensions of the sample x. Script ending Is there any way to open the TSTT file and plot this data in gnuplot, the matplob my scatter plot looks like this I want to show this image Map of contour map or density with color code bar My X-X 2.5- At a distance of 3.5 and at the distance of 110-180...

Magento - Which "Shopping Basket Price Rules" have been applied to the cart? -

I would like to exclude a list of "shopping basket price rules" that have been applied in the current basket. I can not find the code for this! Can you help I can take out the name of the discount voucher in this way: Gungo echo :: MillModel ('Sales / Rules') - & gt; Load ($ -> this (& quot; getQuote () -> getCouponCode (), 'code') -> GetRuleId ()) - & amp; Gt; getName (); But I have been stuck on any of the automatic discounted basketball discounts. I do not know how to see them. I mage :: getSingleton ('checkout / Session ') - Try getVote () -> GetTotals () , but Magento should run out of memory because I only get a white screen. copy $ $ $ $ $ this- & gt; render total ($ total ['discount']); This row can be displayed in either self , Or its data may be removed.

javascript - Dropdown to modify textbox value with knockout -

निम्न HTML / जावास्क्रिप्ट एक ड्रॉपडाउन मेनू बनाने का मेरा प्रयास पाठ बॉक्सेज़ में दो मानों को संशोधित करता है। & lt; प्रकार चुनें = "दिनांक" डेटा-बाइंड = "विकल्प: डेटारंग, विकल्प टेक्स्ट: 'श्रेणीनाम', विकल्पपरिवर्तन: 'चुनें'" & gt; & LT; gt चयन और; & Lt; br & gt; & Lt; इनपुट प्रकार = "तिथि" डेटा-बाइंड = "मान: श्रेणी स्टार्टवैल, वैल्यूअपडेट: 'बाद में डाउन'" / & gt; & Lt; br / & gt; & Lt; इनपुट प्रकार = "तिथि" डेटा-बाइंड = "मान: श्रेणीःस्टॉपवाल, वैल्यूअपडेट: 'बाद में डाउन'" / & gt; & Lt; स्क्रिप्ट प्रकार = "टेक्स्ट / जावास्क्रिप्ट" & gt; Var रेंजवैल्यू = फ़ंक्शन (नाम, स्टार्टवैल, स्टॉपवैल) {this.rangeName = name; This.rangeStartVal = startVal; This.rangeStopVal = stopVal; वापसी }; Var viewModel = {dateranges: ko.observableArray ([नया रेंजवैल्यू ("आज", "2014-04-28", "2014-04-28"), नया रेंजवाले (...

Complete overwrite of current version of android app with update -

I'm just thinking that this is a way to set up via the manifest or elsewhere when users update your app Does it completely overwrite the current version on the device? I know that when the user updates, data etc. from the old version is updated. I'm looking to set it up like this that every time the user updates the app from the Play Store So if anyone has any idea or how to do it, then how will I hear or hear them. Gary Google Play manages the version number from your manifest. So the update for your app will be completed when your version number changes. If you want to blow up your data after the update, then I recommend that you keep the version number as part of your saved data. Then, when it is updated, it can see that the version number is different and the data needs to be reset.

view all customizations in MS Dynamic CRM 2011 -

We had optimized a solution for our dynamic CRM 2011, but that person has left the project Know what adaptations were done and were published when I went to the "Customize Systems" section, it shows all the components, I should know what customization has been done and it has been published. New to me, so please Please be gentle: 0) Thank you! I'm afraid that it would be really complicated but since CRM 2011, the available metadata changes message Try to -

SQL Query to get results that match between three tables, or a single result for no match -

Is there a way where the clause is to check that there are zero matches between the tables for the first table, And displays a line or results? I am trying to get results which looks like this: + ---------- + --- ----- - + ----------- + ---------- + ------------- + | Results | + ---------- + ---------- + ----------- + ---------- + ---- --------- + | Date | Qatar ID | By date To date | Campaign ID. | 3/1/2014 | 1 | 2/24/2014 | 3/2/2014 | 1 | | 3/1/2014 | 2 | (NULL) | (NULL) | (NULL) | + ---------- + ---------- + ----------- + ---------- + ---- --------- + Combining tables that look like this: + ---------- + ---- --- + ------- + ---- + ---- + ----------- + ----------- + - - ------- + | Table 1 | | Table 2. | Table 3. + ---------- + ------- + + ------- + ---- + + ---- + ---------- - + ----------- + ---------- + | Date | Qatar | | Qatar | SP | SP By date To date | Campaign | | | ID | | ID | ID | | ID | | | ID | + ---------- + ------- + + ------- + ---- + + ---- + ---------- - +...