Hey thanks for the reply. That is correct. All that is listed under User Manager for the script is login.bat
I will check out kixstart.
Don
"I feel more like I do now than when I got here."
~ Defcon Moderator ~
C:\WINNT\system32\Repl\Import\Scripts\login.bat
And, as it should, it appears at:
\\server\NETLOGON\login.bat
Thanks
"I feel more like I do now than when I got here."
~ Defcon Moderator ~
I have both 98 and XP clients on an NT 4 domain. Clients running XP SP2 are not executing the script:
net use f: "\\gateway server\g"
net use g: "\\gateway server\f"
net use h: /home
net use p: "\\gateway server\ppc"
net use t: "\\gateway server\f"
net use lpt2: "\\gateway server\epsonlq-"
net...
I get the table to update the field with:
UPDATE TabA
SET TabA.Numb = '::Numb::', TabA.Jobs = '::Jobs::', TabA.Desc = '::Desc::'
WHERE TabA.PRACTID = '::PRACTID::'
I have not had to implicitly declare the table before. Why would I need to declare the table implicitly for text or memo...
I have noted that I can update numeric fields and text fields that are set to length of 50. For text fields set at 255 length or for type=memo, I cannot update. Is there some constraint that I don't know about?
Don
"I feel more like I do now than when I got here."
~ Defcon Moderator ~
For anyone who cares, I discovered when usign the WHERE clause, the syntax must be as follows:
- For numeric fields -
WHERE this_value = ::that_value::
- For text fields -
WHERE this_value = '::that_value::'
"I feel more like I do now than when I got here."
~ Defcon Moderator ~
Can't Update Text or Memo field - using FP 2002 w/MSA DB backend.
For this one update I have 3 fields that are affected:
Numb - Number,double
Jobs - Number,double
Desc - Memo (also tried converting to text)
This portion works:
UPDATE TabA
SET Numb = '::Numb::', Jobs = '::Jobs::'
WHERE PRACTID...
I am using FP 2002 w/MSA DB backend. SELECT statements work fine. I get the the following error when executing and UPDATE query:
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC...
FrontPage 2002, Access 2002
I am using an example from
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm
I created and ASP (search1.asp)
I created a form and populated one drop down list with a DB Query. Ex:
SELECT DISTINCT [TTR Data].State
FROM [TTR Data];
The action of the form is...
Did you ever find a solution to this? I have an Access 2002 DB and am using an ASP to access it but am having difficulty getting the DB to return only what I asked for.
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.