Viewing 15 posts - 16,771 through 16,785 (of 18,926 total)
You'd be the first to understand all this by himself.
Up to the challenge
?
June 14, 2005 at 1:43 pm
Is it possible that the user doesn't have permission to run FileProperty (can't find any info about the minimum permission required)?
June 14, 2005 at 1:42 pm
As I explained you'd need to replace all the (') with (''). Or you could create a stored proc and avoid the problem altogether. It would also shield...
June 14, 2005 at 1:38 pm
You only have 2 minutes to cut down... shouldn't be too hard
.
June 14, 2005 at 1:29 pm
One last question (I promise
).
Is there a possibility that you'd have more than 1 record for the same date (to the minute,...
June 14, 2005 at 1:21 pm
Create a temp table with the same structure as the results then do this :
Insert into #temp (col1, col2, id) exec(@Statement)
June 14, 2005 at 1:18 pm
As always, I guess it depends
.
June 14, 2005 at 1:16 pm
Sounds like dynamic sql to me.
Can you post the code you are using the create the query and execut it.
Pre-hint... double quote your quotes (' becomes '').
June 14, 2005 at 1:14 pm
The code seems alright, the only small idea I have is to change the double quote with a pair of single quotes.
The real question is what are you getting?
What should...
June 14, 2005 at 1:12 pm
Here's the code I use in vb for such a situation
Private Function exec_AutoExecPinTableNumbers(Optional ByRef ReturnValue As Integer) As Integer
On Error GoTo Gestion
Dim MyCmd As ADODB.Command
Set MyCmd = New ADODB.Command
MyCmd.CommandText =...
June 14, 2005 at 1:07 pm
Why would they call you if you don't work there anymore??
They'd have to keep me on payroll to keep me on call
.
June 14, 2005 at 1:01 pm
I've already seen a thread with 10 answers in 15 minutes... This was a slow one by our standards
.
June 14, 2005 at 1:00 pm
everyone. The only difference is that the managers can update the table directly while public must use the procs.
June 14, 2005 at 12:50 pm
if there are only 10, do you want only the first, or the first and tenth?
June 14, 2005 at 12:48 pm
Viewing 15 posts - 16,771 through 16,785 (of 18,926 total)