|
If the ID is an incrementing number you could get the last one by using this SQL statement:
SELECT MAX(ID) AS LAST_ID FROM LINKS
This will return a recordset with the max number in the field ID of the table LINKS and give it an alias of LAST_ID ...
objRS("LAST_ID")
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
I am new to COM. I have been trying to incorporate the WebBrowser control into an MFC program. I have been using as an example and article from MSDN -http://www.microsoft.com/mind/0798/webbrowser.asp.
In this example VBScript is used. I have been trying to use JavaScript instead. I am unable to change a value with a COM method when I pass a value from Javascript;
IN VBSCRIPT:
sub get_property_value_onclick()
i=window.external.get_propert(property_name.value, value)
if i<>0 then
property_value.value=value
MsgBox property_name.value & " = " & value, 0, "Successfully retrieved property"
else
MsgBox "Cound not find value for property '" & property_name.value & "'", 0 , ""
end if
end sub
In Javascript:
function get_property_value_onclick(namevalue,value)
{
var value = "test";
var i = window.external.get_property(property_name.value,value)
if (i != 0)
{
property_value.value=value;
var strMsg;
strMsg = "Successfully retrieved property:" + property_name.value + " = " + value ;
alert( strMsg);
}
else
{
var strMsg;
strMsg = "Could not retrieve" + property_name.value + " = " + value ;
alert( strMsg);
}
}
The COM Method:
HRESULT my_application::get_property(LCID lcid,
WORD wFlags,
DISPPARAMS* pdispparams,
VARIANT* pvarResult,
EXCEPINFO* pexcepinfo,
UINT* puArgErr)
{
if (wFlags & DISPATCH_METHOD)
{
if (pdispparams->cArgs!=2)
{
return DISP_E_BADPARAMCOUNT;
}
// force to string
VARIANT arg1;
VariantInit(&arg1);
HRESULT hr=VariantChangeType(&arg1,
&pdispparams->rgvarg[1],
0,
VT_BSTR);
if (FAILED(hr))
{
*puArgErr=1;
return hr;
}
string str;
com_util::bstr2string(arg1.bstrVal,str);
// try to find element
string2variant_map::iterator it=propertymap.find(str);
if (it==propertymap.end())
{
if (pvarResult)
{
V_VT(pvarResult) =VT_BOOL;
V_BOOL(pvarResult)=FALSE;
return S_OK;
}
if (!pexcepinfo)
{
return E_INVALIDARG;
}
// raise exception
memset(pexcepinfo,0,sizeof(EXCEPINFO));
pexcepinfo->wCode =1001;
pexcepinfo->bstrSource =SysAllocString(L"WebBrowser Demo");
pexcepinfo->bstrDescription =SysAllocString(L"No entry for the key");
return DISP_E_EXCEPTION;
}
hr = VariantCopy(pdispparams->rgvarg[0].pvarVal,&(*it).second);
if (pvarResult)
{
V_VT(pvarResult) =VT_BOOL;
V_BOOL(pvarResult)=TRUE;
}
return S_OK;
}
return DISP_E_MEMBERNOTFOUND;
}
The function VariantCopy(pdispparams->rgvarg[0].pvarVal,&(*it).second);
returns a bad varibale HRESULT. Bu tit works OK in VBSCRIPT. Any idea on how to solve this?
thanks,
RAM_MR
|
|
|
|
|
Greetings. My question is in regards to DSN connections. I need to set the browser permissions to RWD in order to create and update the database. However, this means that any person that knows the full address of the database can get access to it. Is there a way to prevent this other than setting a password to the database, as I have other files in that folder?
THank you
Santiago
Santiago Suárez R.
|
|
|
|
|
check this out:
http://www.canhost.ca/asp.html
regards,
Christian Toivola
|
|
|
|
|
PLEASE HELP IN FINDING OUT SOLUTION . A LOGIN PAGE WITH
CUSTOMER NAME ADDR PHONE NO AND EMAIL ID AND ON SUMISSION IT SHOULD LINK TO ANOTHER PAGE CONTAINING THE DETAILS OF THE CUSTOMER AND INTIMATING HIS SUCESSFUL REGISTRATION.
|
|
|
|
|
JOTD's are better shared in the lounge... 
So few words, and yet so precise! Megan, you're a poet of mathematical accuracy! - Jörgen Sigvardsson
|
|
|
|
|
"Ask not for whom the bell tolls;
It tolls for thee..."
|
|
|
|
|
You can be such an evil cow!
Nice! 
"I have a strange ginger man living on my roof!"
"One of the most important things you learn from the internet is that there is no ‘them’ out there. It’s just an awful lot of ‘us’."
-Douglas Adams
Jonathan 'nonny' Newman
Homepage [www.nonny.com] [^]
|
|
|
|
|
Jonny Newman wrote:
You can be such an evil cow!
Nice!
So few words, and yet so precise! Megan, you're a poet of mathematical accuracy! - Jörgen Sigvardsson
|
|
|
|
|
http://www.sitepoint.com/articles/770/33
srikanth
|
|
|
|
|
What a JOTD???
"Two wrongs don't make a right, but three lefts do!" - Alex Barylski 
|
|
|
|
|
Hockey wrote:
JOTD
Joke Of The Day.
"Ask not for whom the bell tolls;
It tolls for thee..."
|
|
|
|
|
Ahh....
now it makes sense...
"Two wrongs don't make a right, but three lefts do!" - Alex Barylski
|
|
|
|
|
http://www.jsptut.com/Loginforms.jsp
http://www.jguru.com/faq/JSP
check out these sites u may get some useful info
|
|
|
|
|
http://www.sitepoint.com/article/770/33
http://www.sitepoint.com/article/305
http://forums.devshed.com/archive/9/2002/01/4/29371
check these sites it there is source code in the first link,
and other two r tutorials
Srikanth
|
|
|
|
|
so far, I've stumbled across godaddy.com for a domain name @ 9/yr and
edatarack.com for decent hosting @ 3/mo...
This is for a simple little website - nothin fancy...
Am i on the right track?
Thanks
...Steve
|
|
|
|
|
Check out tophost.com
You can find a hosting company which fits your exact needs i'm sure
Cheers
"Two wrongs don't make a right, but three lefts do!" - Alex Barylski
|
|
|
|
|
Yes GoDaddy.com for domains is good.
And for searching for Web hosts I like:
http://www.hostsearch.com/s_power_n.asp
Best regards,
J. Paul Schmidt
http://www.Bullschmidt.com - Freelance ASP Web Developer
http://www.Bullschmidt.com/DevTip.asp - ASP Developer Tips
|
|
|
|
|
Steve Hazel wrote:
I've stumbled across godaddy.com for a domain name @ 9/yr
I use DotYou.com[^] for domain names. I have around 30 of them and DotYou provides full DNS support. Have had no major problem in the two years I have been using them.
Rocky Moore <><
|
|
|
|
|
A website I've been working on for a while requires a user logon; the user info is checked and a session variable keeps track of whether the user is allowed to proceed. It worked perfectly yesterday, but last night I installed the .NET Framework. Today it doesn't work - What changed? Here's the code:
In global.asa -
Sub Session_OnStart
usrOK = False
currTbl = ""
currRec = ""
update = "No"
End Sub
In login.asp -
If (strUser="member") AND (strPass="webuild") Then
Session("usrOK") = True
End If
If Session("usrOK") = False Then
strHTML="You are not authorized to view this page" &_
""
Out(strHTML)
Wait(2)
Response.Flush
Server.Transfer("maintain.asp")
Else
'blah, blah, blah
Just for good measure, I checked the site settings in IIS to see if they'd been changed. There were no changes that would affect this routine, and session settings are still where I left them. Maintain.asp is the entry point where I obtain user id info, and Wait() is a delay function in a SSI file. Any ideas?
"Ask not for whom the bell tolls;
It tolls for thee..."
|
|
|
|
|
That is very strange. We have plenty of ASP websites running on our box that use Sessions and the global.asa. When we installed .NET Framework on that box they all carried on running just fine.
This bit of code, Server.Transfer("maintain.asp"), though worries me. Why are you using Server.Transfer? It might be part of the problem, not sure though.
Also, and forgive me for asking, but you are making sure that you are not mixing ASP and ASPX pages in your app? e.g. You are not redirecting from an ASP login page to an ASPX detail page for instance.
Paul Watson
Bluegrass
Cape Town, South Africa
Chris Losinger wrote:
i hate needles so much i can't even imagine allowing one near The Little Programmer
|
|
|
|
|
Paul Watson wrote:
Why are you using Server.Transfer? It might be part of the problem, not sure though.
It was the only way I know to reload the first page (where user credentials are entered) using ASP. If it's a problem today, it should have been a problem yesterday, as well, along with the several weeks I've been using it reliably. I haven't made any aspx pages yet, so mixing pages is not a problem, either.
I've had trouble with session variables before, with some of them in global.asa being correctly intialized, but others being left undefined for no apparent reason. But this one has worked perfectly since the day I wrote it. I've read many warnings to avoid session variables as unreliable entities in books and on the web, so I haven't been concerned about the occasional eerie failure as long as there was another way to get the job done.
I just love mysteries... I can always count on Windows and IIS to keep me entertained.
"Ask not for whom the bell tolls;
It tolls for thee..."
|
|
|
|
|
Roger Wright wrote:
It was the only way I know to reload the first page (where user credentials are entered) using ASP
The normal way is to use Response.Redirect "filename.asp"
Roger Wright wrote:
If it's a problem today, it should have been a problem yesterday
AFAIK Server.Transfer does a whole lot more than Response.Redirect, which might be what is causing the problem. You are right though that installing the .NET Framework should not have caused a problem. Server.Transfer though generally is used on server farms where you need Session data to move from one server in the farm to the other. Response.Redirect will not do this. If I start on Server1, some Session info is captured and I am then moved to Server2 without a Server.Transfer then I loose that Session info.
I don't know actually Roger, searching Google now for people who have had a similar problem to you. As you say " I can always count on Windows and IIS to keep me entertained"
Paul Watson
Bluegrass
Cape Town, South Africa
Chris Losinger wrote:
i hate needles so much i can't even imagine allowing one near The Little Programmer
|
|
|
|
|
You're not going to believe this (well, maybe you will), but after spending the morning trying to figure out what is going on today that wasn't yesterday I walked away from it for a couple of hours, then returned to it. Now it's working perfectly, though I've changed nothing. I think I'll look at that Redirect option as you suggested. Thanks!
"Ask not for whom the bell tolls;
It tolls for thee..."
|
|
|
|
|
Paul Watson wrote:
The normal way is to use Response.Redirect "filename.asp"
I will have to disgree with you. Response.Redirect works in conjunction with the browser. IIS sends a response with HTTP status code 302 and the new url to the browser when you call Response.Redirect. The browser than renavigates to the page. Server.Transfer is more efficient in the sense that it doesnot cause any extra network trips look at this page which explains it more clearly.
http://msdn.microsoft.com/library/en-us/iisref/htm/ref_vbom_seromtr.asp?frame=true[^]
One of the things I learned involved copying & pasting the code. You'll notice that some of the code is virtually the same for each player, I had forgotten to change the files for player 2 for upgrade. I finally noticed it and provided the fix.
Rodney Yates in Points of Interest in this article
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
