Search results for query: *

This is part of my script. I am getting "]" error. Can some please help. Thanks Set objLst = objXML.selectNodes("//LOCATIONS/LOCATION[@AGENTID=10 OR @AGENTID=12]") noOfHeadlines = objLst.length For i = 0 To (noOfHeadlines-1) Set objHdl = objLst.item(i)...

How can I restrive the elements to a specific attribute eg. 102? This is my XML: <vacancy> <job id="101"> <reference>101</reference> <title>title 1</title> </job> <job id="102"> <title>title 2</title> </job> </vacancy>

I have been give a list of company names and postcode. I have to set up a ASP.NET page up that allows me to enter a postcode and it will display all the company names with from that postcode. This is easy, if the details are stored in a Database. But, are there other options, if theres is no...

I need some advice from any Dotnetnuke professionals or any CMS pro out there. Please advice on the following situations: 1. How to decide whether a particular job should be build in CMS? 2. If lots of programming and customizing is required, is CMS still suitable? 3. What is the best developer...

Does anyone know whether VISUAL STUDIO 2005 comes with Rich Text Box for WEB?

Hi.. I am creating a form and I need a script to validate the date of birth entered to check whether they are under 14. Does anyone know how to do it?

I have an asp form that submits customer records to a registration table. eg ID,FIRSTNAME, LASTNAME, TSTAMP Each record is timestamped with getdate() I need a query that returns the count of records group by WEEK...a start of a week is MONDAY...and end of a week is a SUNDAY. eg. START DATE...

I need some help. I am building a corporate website that contains dynamic contents. One of the requirements is to have a clickable element that will popup a printable version of each web page. It has to take into consideration of solving paginating issues...eg. so that a table of results doesnt...

I have the following script. its uploading a file to the following directory path test/myfolder/uploaded_images Call objUpload.File(x).SaveToDisk(Server.MapPath("uploaded_images"), theFileName) The file containing the script above MUST be place in the MYFOLDER If I want a file to be...

I got a stored procedure that has 3 update queries. Because of the size of the updates that takes place, is there a way to say allow a rest interval between each process, so that the earlier process completes properly. Or slow the process in general to avoid hanging?

can someone please tell me what setup do I need to do to be able to capture chinese charater in the database? The fields are set to NVARCHAR.

I got a table name RESULTS. eg: ID|QUESTION|ANSWER ------------------ 1 | Q1 | a 1 | Q1 | b 1 | Q2 | c 2 | Q1 | a 2 | Q2 | c 2 | Q3 | d 2 | Q3 | e I need to display it the following way: ID|Q1|Q2|Q3 ----------- 1 |a |c | |a | 2 |a |c |d |e Can someone...

Hi. Can someone show me how to concatenate multiple record into one row. Currently the query below returns something like: 3478|C 3478|A 3490|A 3490|B 3490|C But I want it to return like this: 3478|C, A 3490|A, B, C How do I do it? SELECT CUST_ID, max(case when QUESTION_NUM = 'Q10' then...

I got an application that needs to be executed on the 1st of every month for 5 days....and then the 15th of every month for 5 days. I can get the schedule task to execute it but I need a script that will "refresh" or "reload" the application everyday for 5 days and then close. Any ideas?

I got a c# application that on the 1st of every month it will be run and left on until the 5th of every month. I need the application to check the days between the 1st and the 5th whether it is a weekend or not. If it is a weekend the application will not process anything but will still be on...

This is my current table ID | Q_ID | A_ID ---------------- 11 | 11 | 100 11 | 12 | 200 11 | 13 | 333 11 | 14 | 344 12 | 11 | 555 12 | 15 | 557 12 | 16 | 577 Can someone show me a QUERY how to display it in the following format: ID |11 | 12 | 13 | 14 | 15 |16...

ASCII wont work what happens if A = 1 B = 2 C = 3 D = 4 and the result is 4,4,1,2? the average is 2.75. That wont be right. Cause the D or 4 is the major reaccuring one.

I got a database that looks like this ID|Q1|Q2|Q3|Q4 --------------- 11|A|A|C|B 13|C|C|C|A Q1 to Q4 contains the answer of a multiple choice question I need to a query that can return the average answer in the for below eg ID|Average ---------- 11|A 12|C Can anyone help?

But if I use DTS it is fine.

Im getting this error when I try doing a bulk insert: Server: Msg 4864, Level 16, State 1, Line 1 Bulk insert data conversion error (type mismatch) for row 2, column 3 (last_sales_date). This is how the txt file looks like: ID,NAME,LAST_SALES_DATE ---------------------- 10|Terry|30/06/1999...