Robert Rodgers
|
Posted: 05/13/2003, 1:22 PM |
|
Hi All,
In MSSQL I can submit a query that returns a guid with this statement.
SELECT NEWID() as xguid
Any Idea how to get an MDB to return a guid like this?
thanks.
rob
--
"Every absurdity has a champion to defend it"
Oliver Goldsmith
++++++++++++++++++++++++++++++
|
|
|
Robert Rodgers
|
Posted: 05/13/2003, 2:30 PM |
|
Never mind.
Using ASP I can get a GUID this way.
<%
Dim TypeLib, GetGuid
Set TypeLib = Server.CreateObject("Scriptlet.TypeLib")
GetGuid = Left(CStr(TypeLib.Guid), 38)
Set TypeLib = Nothing
response.write(GetGuid)
response.end
%>
Thanks.
Rob
--
"Every absurdity has a champion to defend it"
Oliver Goldsmith
++++++++++++++++++++++++++++++
"Robert Rodgers" <rrodgers@sylvancomputing.com> wrote in message
news:b9rk5t$uh8$1@news.codecharge.com...
Hi All,
In MSSQL I can submit a query that returns a guid with this statement.
SELECT NEWID() as xguid
Any Idea how to get an MDB to return a guid like this?
thanks.
rob
--
"Every absurdity has a champion to defend it"
Oliver Goldsmith
++++++++++++++++++++++++++++++
|
|
|
|