Hi I am trying to restoring a 2.5 GB VSS archive file and neither Restore Wizard or the SSRESTOR command failed. Neither of them can get the list of projects archived in the SSA file. Microsoft has a article on this http://support.microsoft.com/kb/321088, but it doesn't provide any solution. I...
Hi All,
I am trying to sort the group based on a calcualted average value. The data look like
NAME, TYPE, VALUE
N1, A, 4
N1, A, 5
N1, B, 4
N2, A, 1
N2, B, 2
N2, B, 4
I grouped the records by Name and the average is calculated based on Type. Each group has two average, Average of Type A and...
I am using simple search in CFSEARCH and need to find a word like "@Google". CFSearch always ignores the @ sign and find all the documents with word "Google". I only want it to match the word where there is a @ in front of Google.
Anyway to do that? I have tried the backslash in SIMPLE or...
Hi All,
I have data contained in XML file and SQL database. What I'd like to do is to create a DataSet with a DataTable containing data coming from the XML file, and retrieve from the SQL server only data that match a field in the XML datatable, for example DocID.
The xml might look like...
I created a MDI and added two child forms. Each of the child form had a private member,
private MODI.Document modiDoc;
when I clicked on a button, a BackgroundWorker will start and use the modiDoc to do some processing.
Everything worked fine if I had only child form. However, if opened two and...
I am working on an intranet application and use Access as the database.
There is a query that I have
<CFQUERY DATASOURCE="#DSN#" NAME="GET_SEARCH_RESULT">
SELECT * FROM WL_TREES
WHERE TREENAME LIKE '3*'
</CFQUERY>
It returns nothing in ColdFusion, if I copy just the SQL and run it in Access...
Hi All,
I am using Adobe Pro 7.
I need to process a large amount of PDF files and save text extraction to plain text file. The problem was that if the PDF wasn't OCRed then nothing would be saved to the text file. I got the other part working except the OCR.
Is there a method in the object...
I am using CF4.5. yes, it is old, but the client didn't want to update it... :(
When I pass search criteria like
"New York" AND London
including double quotes.
it will give me what I was looking. Phrase "New York" and London word.
However, if I passed in just
"New York"
it returned no result...
Hi All,
I am not sure if that is even possible.
I have a main html page with a FROM in it. it also contains a IFRAME which load html file from another site. Is it possible to write javascript in the IFRAME html page to udpate a Form value in the main page?
Thanks in advance for any tips!
tofuTnT
Hi All,
I am trying to fix this issue with my CSS. The page is located at http://xkxtnt.mysite4now.com/css.html
I get exactly what I want in FF. That is SIDEBAR is on the right side of CONTAINER, FOOTER is at the bottom (clear both), most importantly, any table inside CONTENT with width over...
Hi All,
I have a table like the following:
MsgID, ParentMsgID, Title
1, 0, Title 1
2, 1, Title 2
3, 2, Title 3
4, 1, Title 4
5, 0, New Title
6, 5, New Title 2
Basically, message 1, 2, 3, 4 belong to the same thread. 5, 6 belong to another thread.
What I'd love to have are two tables based on...
hi all,
I am looking for way to write a query that would give me what I want.
Basically, there are four tables:
Event
EventID
EventName
EventDate
EventToSubType
EventID
SubTypeID
SubType
SubTypeID
SubTypeName
MasterTypeID
MasterType
MasterTypeID
MasterTypeName...
I have a DataGrid in my web form and when I disabled it by using
dgDetail.Enable = false
The color of header text was turned into grey and was barely readable (in IE only). I guess it has something to do with IE. is there any way to fix that?
Thanks
www.ezonetechnology.com New York Desktop...
Hi All,
I have wrote a query for MySQL 4.1.4-gamma. Now I moved the file to my hosting server and the query won't work any more because their MySQL server was still 4.0.22 and it didn't support subquery.
The structure of the table is as follow.
table1: Product
product_id (PK)...
Hi,
I wonder if there is anyway you can run a shell command inside SQL.
for example "SELECT * FROM table;execute shell command"
I had googled around and didn't find anything.
Regards,
tofuTnT
Hi All,
I am trying to insert a chart into my report and ran into some problem. Here is the structure of my report
GH1 - Class
GF1 #running_total1, #running_total2
In the chart I want to have Class as X-axis and #running_total1 and #running_total2 on Y-axis. So I put Class field in "On...
Hi All,
I need to install a SQL 2000 Standard Version on my server, however there is already a backup software that is using MSDE as its db engine. May I still install Standard version on the same server? will they have conflict?
Thanks,
Song
Hi,
I am getting this error on all of WINXP computers on my network.
Event ID: 1054
Source: Userenv
Type: Error
Category: None
Description:
The description for Event ID ( 1054 ) in Source ( Userenv ) could not be found. It contains the following insertion string(s): The specified domain...
Hi All,
I have two tables: one with name info and the other one has gifts info. The relationship is one to many.
What I want to see on my report is as follow:
(header row) | FY03 | FY02
Name | gift date/amount | gift date/amount...
Hi All,
Can anyone take a look at the following report:
http://home.earthlink.net/~song.lin/crystal.rpt
http://home.earthlink.net/~song.lin/db1.mdb
and tell me how I can get the detail section to show correctly? That is to show only one copy of the dates and one copy of the degrees for each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.