Hi,
I have a MS SQL query that is selecting a field and it is being chopped off for some reason it is cutting off text at 257 characters.
Is there some kind of default cut-off for retrieving results with MSSQL and PHP?
I'm honestly clueless as to why this is happening. ANY guidance would be greatly appreciated
I am developing a vb.net application in SQL server 2005 ,now i would like to import MS access database tables from a network into sql server 2005 database, using stored procedure or vb.net code without using SQL server 2005 Wizard . please find a sollution thanks a lot.
I've been asked to convert several hundred MS Word 2002 Templates (on the PC) to work on the Macintosh. I have to evaluate whether the Word Templates can be run in iWork Pages and Microsoft Word for the Mac. The biggest issues that I've found thus far are that I'm unable to convert the following -
Macros
WordBasic code
Visual Basic
Has anyone here ever done this before and can provide any suggestions?
I have a .sql file from a MySQL dump containing tables definitions and the data to be inserted in this tables. How can I convert this database represented in the dump file into a MS SQL server database?
I need to get a list of all tables that are published for replication from MS-SQL 2005/2008 databases. Is there a system stored procedure or a query I could run to generate such a list?
Thank you,
I have table with 3 columns(smallint) in MS SQL 2005.
Table Ratings
ratin1 smallint,
ratin2 smallint
ratin3 smallint
These columns can have values from 0 to 5
How to select average value of these fields, but only compare fields where value is greater then 0.
So if column values are 1,3,5 - average had to be 3
if values are 0,3,5 - average had to be 4
We currently run pfSense with no problems, however we are looking at TMG as it is included in our partner subscription to MS and allows Windows 7 DirectConnect features to our domain for off-site users.
I have had a google, but there don't seem to be any comparisons of TMG to pfSense.
Anyone have experience/knowledge of this?
Our infrastructure is Windows Server 2008 R2 behind pfSense at the moment.
I'm searching since hours how to insert the entailment symbol (http://en.wikipedia.org/wiki/Mathematical_symbols) into a MS Word 2007 document. Any hints?
I need to write a batch program to end all MS office communicator tasks with window titles (usually ending with pattern "- Conversation" .
I tried
taskkill /FI "WINDOWTITLE eq *Conversation" /IM communicator.exe
but the wildcard pattern starting with a '*' does not seem to work. Gives the folowing error
ERROR: The search filter cannot be recognized.
any suggestions for a workaround would be greatly appreciated!
I heard about the routing feature available in micro soft products (word ,doc) .through which we can route a document in MS outlook.I have no idea how to initiate it.Can some one please tell me the procedure for the same
Does the CPU is run at 100% or near full capacity when the computer is booted into MS-DOS? Will the CPU temperature become higher even though we are not running any program in DOS mode?
In Windows, we can see the CPU usage in % of utilization in Task Manager. From what I heard, CPU is running at near 100% capacity in DOS OS or in the BIOS MAIN screen.
Is this caused by lack of CPU optimization in DOS OS?
All -
I'm trying to understand the first section of the Map file produced by the MS Visual Studio 2005 linker. I know it has something to do with memory sections, but can someone help me decipher it?
Timestamp is 4b4f8d2b (Thu Jan 14 14:31:23 2010)
Preferred load address is 00400000
Start Length Name Class
0001:00000000 0028b752H .text CODE
0002:00000000 000001b4H .idata$5 DATA
0002:000001b4 00000004H .CRT$XCA DATA
0002:000001b8 00000004H .CRT$XCAA DATA
0002:000001bc 00000004H .CRT$XCC DATA
0002:000001c0 00000004H .CRT$XCZ DATA
0002:000001c4 00000004H .CRT$XIA DATA
0002:000001c8 00000004H .CRT$XIAA DATA
0002:000001cc 00000004H .CRT$XIC DATA
0002:000001d0 00000004H .CRT$XIZ DATA
0002:000001d8 00025288H .rdata DATA
0002:00025460 00000004H .rdata$sxdata DATA
0002:00025464 00000004H .rtc$IAA DATA
0002:00025468 00000004H .rtc$IZZ DATA
0002:0002546c 00000004H .rtc$TAA DATA
0002:00025470 00000004H .rtc$TZZ DATA
0002:00025478 0000007cH .xdata$x DATA
0002:000254f4 00000028H .idata$2 DATA
0002:0002551c 00000014H .idata$3 DATA
0002:00025530 000001b4H .idata$4 DATA
0002:000256e4 00000542H .idata$6 DATA
0002:00025c26 00000000H .edata DATA
0003:00000000 000f070cH .data DATA
0003:000f0720 001f1280H .bss DATA
I am trying to register a plugin for MS CRM, the situation is as follows. It's an IFD deployment and everytime that I connect using the Microsoft provided plugin registration tool I get the following error message.
Unhandled Exception: System.Net.WebException: The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="https://URL/signin.aspx?targeturl=https%3a%2f%2fURL%2fMSCrmServices%2f2007%2fIFD%2fcrmdiscoveryservice.asmx%2fmscrmservices%2f2007%2fad%2fcrmdiscoveryservice.asmx">here</a>.</h2>
</body></html>
The link that I'm using to connect looks like this:
https://URL/MSCrmServices/2007/IFD/crmdiscoveryservice.asmx
Can anyone give me some direction?
Hello,
Ive got a MS Chart control and it works just fine except that I can't figure out how to "format" the Y-Axis. I am adding a lot of double numbers into a Serie but when the double numb are actually whole numbers (20.000000.....) the Y-Axis on my chart shows 20.
example: this serie :
12.32
11.00
10.13
would actually show up like this:
12.32
11
10.13
I have tried formatting the data as I insert it into the serie like this:
serie.Points.AddXY(date.ToString(),double[i].ToString("##.##"));
but that doesn't seem to work.
I've tried to search for a place to format it in Chart.Series[0].* and Chart.ChartAreas[0].* but I didn't find it there.
Thanks in advance,
Regards,
Birgir Hrafn
Does any one know how I would have to change the following to work with ms sql?
WHERE registrationDate between to_date ('2003/01/01', 'yyyy/mm/dd')
AND to_date ('2003/12/31', 'yyyy/mm/dd');
What I have read implies I would have to construct it using DATEPART() which could become very long winded. Especially when the goal would be to compare on dates which I receive in the following format "2003-12-30 10:07:42". It would be nice to pass them off to the database as is.
Any pointers appreciated.
I'm about to start using the MS ReportViewer in a WPF application by placing the ReportViewer in a WindowsFormsHost.
Is this the correct approach? What is the best way of designing the reports as you cannot use the ReportViewer at design time in a WindowsFormsHost.
Is it best to create an RDL report in SQL Server and then convert it to an RDLC or maybe to create a new Winforms app to create an RDLC file in a WinForms framework and then copy it to the WPF app.
I will need to filter the reports via dropdowns so there's that aspect to consider too. If anyone out there is already using ReportViewer in WPF I would appreciate some feedback on the best approach.....Many thanks.
I've seen some questions on catching the paste event. This looks helpful.
But I want to prevent paste on a designmode iframe from happening when the pasted content is not plaintext, but comes from MS Word or other WYSIWYG editor.
What is experience on that?
I suppose I should catch the event (bind to iframe or to its body?) and look for some specific tags in the clipboard. What content does Internet Explorer add every time?
[edit]
After doing more research I see there is no easy way to work with clipboard in non Internet Explorer browser except some Flash tricks. I don't want them. How can I detect paste in Firefox and others then?
Hi
I have a webservices running on a server, which converts word document into pdf using word automation.
I have given a windows network user account in the identity tab on the MS Office word component using the DCOMCNFG.exe.
I am getting below mentioned error
Exception Message: The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
But, if I Remote Desktop into that server using the account mentioned in the components identity tab, then it works fine. If I logoff from that server then its giving the above error.
Anyone got any idea!!
Many thanks in advance
Ive got a MS Chart control and it works just fine except that I can't figure out how to "format" the Y-Axis. I am adding a lot of double numbers into a Serie but when the double numb are actually whole numbers (20.000000.....) the Y-Axis on my chart shows 20.
example: this serie :
12.32
11.00
10.13
would actually show up like this:
12.32
11
10.13
I have tried formatting the data as I insert it into the serie like this:
serie.Points.AddXY(date.ToString(),double[i].ToString("##.##"));
but that doesn't seem to work.
I've tried to search for a place to format it in Chart.Series[0].* and Chart.ChartAreas[0].* but I didn't find it there.
Hi
We're doing mockups/prototyping on a MS Surface device and I wonder if anyone has succeeded in using SketchFlow for this. The problem that I see is that the code generated by the tool uses normal WPF controls (Button, etc.) instead of the contact aware surface counterparts (SurfaceButton) which means that they won't work nice on the surface unless you also use a mouse.
Additionally, it would be nice if it was possible to hook in to other gesture events to trigger sketchflow transitions. Like the pinch gestures to switch page etc.
Has anyone had any success with prototyping for Surface using Sketchflow. If so, how did you do it?
I'm lazy loading my Doctrine classes in my website. Benchmarking has showed that Doctrine::loadModels('models') takes over 100 ms to complete! I have 118 tables in total, but still...
setting attribute to conservative loading:
Doctrine_Manager::getInstance()->setAttribute(Doctrine::ATTR_MODEL_LOADING, Doctrine::MODEL_LOADING_CONSERVATIVE);
running the benchmark part:
$CI->benchmark->mark('Doctrineload_start');
Doctrine::loadModels(APPPATH.'models');
$CI->benchmark->mark('Doctrineload_end');
And the result:
Doctrineload 0.1085 (seconds)
Is this 'normal'?
'context':
Loading Time Base Classes 0.0233
Doctrineinit 0.0435 //doctrine_pi.php file, doctrine configuration + db account
Doctrineload 0.1085
Masterpageset 0.0001
Userload 0.1208 //1 db query
Masterpageaddcontent 0.1565 //1 db query, loading view with some <?=?> php parsing
Masterpageshow 0.0203 //loading view
Controller Execution Time ( Home / Index ) 0.3591
Total Execution Time 0.3826
Hello
I want to write a script for gdb, which will save backtrace (stack) of process every 10 ms. How can I do this?
It can be smth like call graph profiling for 'penniless' (for people, who can't use any sort of advanced profiler).
Yes, there are a lot of advanced profilers. For popular CPUs and for popular OSes. Shark is very impressive and easy to use, but I want to get a basic functionality with such script, working with gdb.