Tuesday, 15 February 2011

windows - How to Inspect ODBC communication, to see the SQL being passed through? -


Is there a device for windows that we can use to inspect any SQL command, which is a specific ODBC Go through the data source?

You can log in to Odbi, whatever is happening:

Attribute to connection to SQL_OPT_TRACE_ON by calling SQLSetConnectAttr and SQL_ATTR_TRACE

/ code> . Therefore, doing so will allow you to enable / deactivate it for connection period.


firefox - Why does Internet Explorer prevent me from accessing the parent window's JavaScript? -


मेरे पास IFrame इसमें एक बटन है, और यह onclick है है:

< प्री> नई विंडो। Parent.UI.Image ('xyz')। AddToCart ();

फ़ायरफ़ॉक्स में, मुझे इस कोड के साथ कोई समस्या नहीं है। IE में, हालांकि, मुझे एक "अनुमति अस्वीकृत" त्रुटि मिलती है।

क्या मुझे एक अलग तरीके से जावास्क्रिप्ट को मूल विंडो में एक्सेस करना चाहिए?

मैंने "विंडो" को हटा दिया और अकेले "माता-पिता" का संदर्भ दिया और यह इसे ठीक करता है।


php - Mp3 Download not functioning -


I am offering a preaching download site and I have a user facing a problem with its download Have any idea how I can improve this code, or maybe send a better header ...

  $ path = "http://www.domain.com / Sermon_files / ".date" Y ", $ array [" Promoted "]). "/". $ Array ["filename"]; $ CorePath = "/home/user/public_html/sermon_files/".date("Y", $ array ["Promoted"]). "/". $ Array ["filename"]; If (! File_exists ($ corePath)) echo "An error has occurred with this download."; } And {header ("PAGMA: public"); // Required header ("End: 0"); Header ("Cash-Control: Required-Modified, Post Check = 0, Pre-Check = 0"); Header ("Cash-Control: Private", Incorrect); Header ("content-type: audio / mp3"); Header ("content-dispute: attachment; filename = \" $ array ["title"]. "\"; "); Header ("content-transfer-encoding: binary"); Header ("Content-Length:". Philips ($ Core Path)); Readfile ($ path); Go out(); }  

Take a look at this thread, I have similar problems: Also consider using Fidler to capture the exact HTTP headers being sent.


jquery - The 'charCode' property of a keyup event should not be used. The value is meaningless -


HTML कोड:

  & lt; input type = "text" id = "गोपनीयता" नाम = "गोपनीयता" आकार = "3" maxlengh = "3" / & gt; दिन  

Jquery code:

  $ ('# गोपनीयता') .keyup (फ़ंक्शन () {चेतावनी ("ठीक");});  

त्रुटि संदेश:

किसी कुंजीप घटना की 'चारकोडा' संपत्ति का उपयोग नहीं किया जाना चाहिए। मान अर्थहीन है।

Jquery कोड काम नहीं करता है.जब मैं कुछ "गुप्तता" में इनपुट करता हूं, तो एक चेतावनी नहीं निकलती.क्या गलत है?

क्या आप डोम तैयार होने तक घटना को बांधने की प्रतीक्षा कर रहे हैं?

ऐसा कुछ मदद कर सकता है: < / P>

  $ (दस्तावेज़) .ready (फ़ंक्शन () {$ ('# गोपनीयता')। कुंजी (कार्य () {चेतावनी ("ठीक");});});  

ios - How to style UITextview to like Rounded Rect text field? -


I am using a text visual as a comment composer.

In the property inspector I can not find anything like a border style property so that I can use a round rack, like UITextField .

So, the question is: How do I like a UITextView like a UITextField with a rounded rectangle?

No built-in style that you do not have to choose, in this quartzakor structure It involves writing some code using:

  // First, you #import & lt; Quartzcore / Quartzcor j & gt; // // // I add the UITXView to the code here, if it is also added to the IB, then it will work if IITextView * textView = [[UITXXL ALL] InitVithframe: CGRactMake (50, 220, 200, 100)]; // UITEFFESTFIELD to see the boundary [textview. Players SetborderRall: [[[UIColor Gray Color] Colophon with Colophon: 0.5] CGColor]]; [TextView.layer setBorderWidth: 2.0]; // The circular corner part, where you specify the corner radius of your view: textView.layer.cornerRadius = 5; TextView.clipsToBounds = Yes;  

It only works on OS 3.0 and above, but I think this is actually the real platform.


soa - Is MSMQ obsolete? -


I'm just talking to a Microsoft MVP, and he told me that MSMQ is obsolete. Is it true? What is the infrastructure for SOA? Well, they released a new version (4.0) with Vista, and it's a clear in WCF:

I have created new services on the basis of this in the last six months, and there is no official MS document. I know that it is aware of it going away.

If you need a reliable message, then there are not very good options if you are already deep in the database land, the service broker can understand, but otherwise ... MSMQ

< / Div>

sql - Cross Database Unions -


My warehouse datamart data is divided into 3 databases on the same server. This proof has three conclusions with the concept project that were loaded in the personal database.

While dragging into a cube, I am essentially doing this:

  SELECT * FROM DB1.dbo.Fact_Pres select Union * DB2.dbo.Fact_Pres union Selection * from DB3.dbo.Fact_Pres  

Should I really strengthen the data in a table? Will this make my processing faster?

I have no problem with disk space - I want to apply the best solution.

In either case, can you help me understand why, why do you suggest that it will be optimal? Cross-Database Query (to a lesser extent) is slower than the database, if you click

If there are three separate tables, then it is advisable to use different schemas within the same DB. If this is a fact table, then it is best to load and use split in a single fact table if the size is very large.

When it comes to ETL, this suggestion should be loaded into a separate schema in the ETL staging table - such as ETL - within the same DB and the fact sheet from there.

Recommendations are from .

Also keep in mind that the foreign key can not be used in the database.