Search results for query: *

I'm working on a small php mysql project for a local university, I'm really keen to use the project to test out some agile development practices, particularly iterative development and test driven development. I'm looking for advise on unit testing tools, which ones are out there, which are...

Please excuse my ignorance, I'm proberbly using all the wrong terms. I have rule set up in Outlook that are triggered when I send or recieve an email, what I'd like to do is trigger a rule when an email is recieved by exchange. I want to send a copy of all email sent to or recieved from anyone...

If I've been tasked to do something at Site 1, Site 2 and Site 125 can I get a single view of all my tasks? Ideally I'd like to see it all in "My Site

I'm messing around with sharepoint with the goal of trying to organise a group of sites so that it mirrors the operationals and project views of our team. Thinking about documents only.... I want to have a site for each project which stores all project documentation (in my case requirements...

Hello I generating an excel worksheet from via a web application. Some data is "rich text" and stored with html tags. When I open the spreadsheet the tags are shoen in plain text i.e. <b>Look at this</b> instead of Look at this Is there a setting in excel that can cause the html tags to be...

In Enterprise Manager I can create a SQL scripted version of my schema. I.e. the script will generate CREATE TABLE and constraints, indexes etc. What I'd like to do is create the schema along with its data. INSERT INTO myTable ...... for all of the data in the schema. Any ideas?

Hello I was wondering if it is possible to suppress the following output when I run an "EXEC sp_rename ......" The COLUMN was renamed to 'Baseline_Value' My aim is to suppress all messages except for error messages. I already use SET NOCOUNT ON. Any ideas?? John

Hi I want to import a table from an old version of our database into our current version. imp <user>/<password>@<oraname> file=<exportfile> tables=table1 full=n The problem is that I want to import the table with a new name. i.e. table2. The most obvious solution is to rename the table once it...

I have some queries that look something like this. SELECT a, b, c, d..... FROM table1, table2 WHERE a = 1 AND b in (SELECT x FROM table3 WHERE x = i) OR b in (SELECT y FROM table4 WHERE y = j AND k in (SELECT x FROM table5...

Why do I get a warning when I run this code? CREATE OR REPLACE PROCEDURE EnvoyDropTable (envoy_table_name in varchar2) AS v_rows NUMBER; BEGIN select count(*) into v_rows from all_tables where table_name = envoy_table_name AND owner = 'ENVOY'; if v_rows <> 0 then drop...

Is there a way to suppress the output from statements such as SP_RENAME and CREATE INDEX. I am using SET NOCOUNT ON to suppress some of the output in my scripts. Ideally I only want errors to be reported back when the script is run. Can anyone help? John

Is there such a thing?. For those who dont know what SQL Server SET NOCOUNT ON does, it stops the positive messages such as the '3 rows updated.' from the output. Cheers John

When I open a recordset with the adCmdTable option does the whole table get loaded into memory? With rs .CursorType = adOpenKeyset .LockType = adLockOptimistic .Open &quot;A_BIG_TABLE&quot;, sConnect, , , adCmdTable End With Or does ADO only get the daya when I...

Hi I need an algorithm to check a text string is a valid <Meta> tag. Has anyone come across scripts which validate HTML? Cheers John

Hi I need to know which of the tables in my database have CLOB columns. Any ideas anyone? Thanks John

Can I implement Wide Character Languages in SQL Server? What data types will I need to use for strings. Could I put a block of Korean text into a Varchar? or would I need to use nVarChar? Thanks John

Hello I develop a Web Application using ASP on IIS4/5 with a SQL Server or Oracle database and some Visual Basic COM Components. Our clients use IE a minimum of V4.01. I have recently been tasked with finding out about the impact Wide Character Languages (Japanese, Chinese, Korean etc) will...

I am wondering if there is a function that returns the number of times a character appears in a string. i.e. x = UnknownFunction('do da do da', 'd'); would result in x = 4 Cna anyone help...please John

On NT I do not have any uninstall or revert to previous version info. Is there any way at all to Install an older version if IE?

I have some Internet shortcuts on my desktop. If there is an instance of IE open the shortcut uses this. Is there a way to open a new IE window. The code behind the shortcut is: [InternetShortcut] URL=http://localhost Modified=9025BEC00C4CC1014D