|
Hi, i am in urgent need of help in creating an asp script. I Will be very
greatful if someone can help me out.
Basically i have the following script that checks the record in the database ,
if it founds one then it dispalys some text on the page. else it inserts a new
record in the database and redirects to the second page.
We are using the following code...
---------------------------------------------------------
sub createNewUserschedule()
Dim strQuery
Dim rsScheduleSpec
Dim rsSchedule
strQuery= " Select * from User_Schedule_info where (UserId=" & UserId & " and
UserScheduleName='" & trim(UserScheduleName) & "')"
Set rsScheduleSpec = Server.CreateObject("ADODB.Recordset")
rsScheduleSpec.Open strQuery, cn, 1,1
If rsScheduleSpec.recordCount <= 0 Then
rsScheduleSpec.close
set rsScheduleSpec = nothing
'if already exists alerts the user
Response.Write("<html> <center><big><BR><BR><BR><BR><BR><BR><BR><BR><BR><b> User
Schedule Already Exists</b> </big></center></html>")
else
strQuery = "INSERT INTO USER_SCHEDULE_INFO
(UserId,UserScheduleName,DateCreated,DateModified) Values ( "& UserId & ",'" &
UserScheduleName & "' ,'" & FormatDatem(date()) & "','" & FormatDatem(date())
& "')"
cn.execute strQuery
strQuery="select UserScheduleId from USER_SCHEDULE_INFO where UserId =" &
UserId & " and UserScheduleName='" & UserScheduleName & "'"
set rsSchedule = Server.CreateObject("ADODB.Recordset")
rsSchedule.open strQuery, cn,1,1
if rsSchedule.RecordCount > 0 then
UserScheduleId=rsSchedule.Fields.Item("UserScheduleId").value
Response.Redirect("UserSchedule.asp?User_Id=" & UserId &
"&UserScheduleId=" & UserScheduleId )
end if
rsSchedule.close
set rsSchedule = nothing
End If
End Sub
'execute the function
createNewUserschedule
--------------------------------------------------------
We are getting the userId and the UserSchedule NAme from a previous form.
But the problem is that in some cases when a new name is provided it inserts the
values in the database but is not able to redirect it to the new page ...
that is although it sends the 302 request but then instead of moving to the new
page it calls the same page and then founds the record and displays the text in
the if condition
Mohit Raj
(mohit.raj@mailcity.com)
|
|
|
|
|
Need more information any way try to change the recordset parameter rsSchedule.open strQuery, cn,1,1 to rsSchedule.open strQuery, cn,1,2
|
|
|
|
|
Hi,
I am giving one report page, which will be used to print on special type of Label printer.
So I need to print the text as laid down on HTML page.
But printer takes by default header and footer of IE, this makes print disturbing.
Any how, I want to ignore this text [ header and footer] at the time of printing.
I had considered Webbroser control, but I could not get the way to hide header and printer.
I had used WebBrowser1.ExecWB 7,-1
but I don't know next argument to send from VbScript/Javascript
Some suggested to change registry value, but I don't think it's feasible, Since user will not accept any registry from Internet.
If any one has idea in above regards or new way to handle from vbscript like Wscript etc....
your suggestion invited.
Thanks.
Haresh Zolapara
|
|
|
|
|
Hi dear,
I want to retrieve some periodical messages from a web service when
I call a main web method of that.
In fact I want to create an event generator by a web service.
For this reason I've created a timer in my web service to send periodical messages ( for example
a counter value that is increasing by timer) to
a client that already has triggered the web service.
But my sample doesn't work properly.
Do you have a good solution.
|
|
|
|
|
I remember we had something like this in ASP.NET forum before and the answer was no timer work there. Cause ASP.NET or WS get one request from client and send one respond to it. Another respond need one request, so in ASP.NET that timer should be placed in javascript, but here I think client should request periodical to get periodical messages.
Mazy
No sig. available now.
|
|
|
|
|
so if i include an external javascript file (so i dont have to have all the same rubbish on every page header) it seems the variables declared within it (ie, preloaded images) arent visible to the page itself ... is that true?
ie, in the external file:
image1 = new image(100,20);
image1.src = "whatever.jpg';
then in the page itself:
onmouseover="pageimage.src=image1.src"
gives me an "object required" error
is it me being an idiot or what?
"there is no spoon"
biz stuff about me
|
|
|
|
|
I use this technique all the time 
yer probably getting the error with pageimage.src=image1.src
If your doing a image rollover, try:
this.src=Image1.src
The word of the day is legs, let's go back to my house and spread the word 
|
|
|
|
|
Assuming I knew exactly what files I wanted to upload (location and all) would it be possible to construct and FORM with hidden elements and upload those files, instead of requiring a user click on browse and add a file that way?
I guess not, then it would be possible for web sites to read 'known' files off your computer each form you submitted...shoot...there goes my idea 
Unless you know of an way of accomplishing this?
Cheers
The word of the day is legs, let's go back to my house and spread the word
|
|
|
|
|
u answered ur own question
its a security feature
"there is no spoon"
biz stuff about me
|
|
|
|
|
crummy
The word of the day is legs, let's go back to my house and spread the word
|
|
|
|
|
Hi,
I am really torned on what would be a good project, i.e., web application, to design, develop, and implement. If you have any suggestions for me, please be my guest. I greatly appreciate your input.
Thanks!!
'Overcome your fears'
|
|
|
|
|
An WYSIWYG HTML editor like htmlArea, but correct all the annoyances like double line on ENTERS and such...
Just a suggestion
The word of the day is legs, let's go back to my house and spread the word
|
|
|
|
|
hi guys and gals,
I got a problem. How to write client side script in ASP .NET using c#. ie How to validate a text box contains user name and password ie whether any value is entered in both the boxes without going to the server.
plz help me.
thanks in advance.
|
|
|
|
|
POKRI wrote:
I got a problem. How to write client side script in ASP .NET using c#. ie How to validate a text box contains user name and password ie whether any value is entered in both the boxes without going to the server.
plz help me.
You don't, you use javascript. C# in an ASP.NET context is server-side only.
And for what you want, you really should use the relevant validator controls instead. Try the RequiredFieldValidator control for starters.
Ian Darling
"The different versions of the UN*X brand operating system are numbered in a logical sequence: 5, 6, 7, 2, 2.9, 3, 4.0, III, 4.1, V, 4.2, V.2, and 4.3" - Alan Filipski
|
|
|
|
|
|
Actually i want to know what are these MM_sr Similarly MM_P Are they properties What are ther uses What are thier purposes How can we find All these type of Properties If there is any article defining than please tell me that too
Regards
minamkhan
Inam
|
|
|
|
|
I don't remember any member MM_sr into the Document object, but I remember this into one Macromedia script, if your page was made in Dreamweaver.
----
hxxbin
|
|
|
|
|
... to see a video
so i used to be able to do this but now all i see is a blank screen while i hear the audio track playing
anybody know the magic incantations required?
"there is no spoon"
biz stuff about me
|
|
|
|
|
If you hear the audio track, and don't see nothing in the play screen, maybe your video is damage. Cuz if you get sound the mediaplayer works fine.
----
hxxbin
|
|
|
|
|
its cool
i got it figured
they changed the clsid
"there is no spoon"
biz stuff about me
|
|
|
|
|
How do you force a refresh of IIS cache using ADSI? I have a web service which calls a VB.NET dll that uses ADSI to query the sites listed in the metabase. The problem is that it does not pick up sites which are added to the metabase unless I restart IIS but if I delete a site, it will be reflected in the ADSI query right away...?
Here is how I am querying:
<br />
Dim objW3Svc As Object = GetObject("IIS://" & m_sServerName & "/W3SVC")<br />
objW3Svc.GetInfo()<br />
Dim ar As New ArrayList<br />
<br />
' Find the sites listed in the MetaBase<br />
For Each objWebSite As Object In objW3Svc<br />
<br />
If (objWebSite.Class = "IIsWebServer") Then<br />
ar.Add(objWebSite.ServerComment)<br />
End If<br />
Next<br />
If it were a permission issue due to the web service calling the VB.NET dll I would not expect the sites to magically show up after an IIS restart. Also the fact that deleted sites do not show up in subsequent queries shows me that ADSI seems to be looking at current data...
Any clues here? 
|
|
|
|
|
Hi,
I need to convert the date which is in UTC format to PST using javascript, i know tht PST is UTC - 8 hours, but i heard tht its not always UTC-8 hrs, it depends on the season too(in winter the time will be adjusted for 1 or 2 hrs ), can any body suggest how to go abt this.
TIA,
sudheer
|
|
|
|
|
If all you need to worry about is PST it's fairly easy - subtract 8 hours from GMT (UTC-0). Daylight Saving Time changes that to GMT - 7 hours. The dates vary each year, beginning on the first Sunday in April and ending on the last Sunday in October. I believe the change officially occurs at 1:00AM on these dates.
If you're coding for the general case, you're in for a fun time. The basic time zone conversion isn't too bad - each time zone around the world is represented as UTC +/- N, where N is the number of time zones east or west of Greenwich, or UTC-0. But determining which areas to include in Daylight Saving Time (the seasonal adjustment you mentioned) is going to be awful. There are countries that don't use it, and states/provinces/counties/cities etc that ignore it even though their countries observe the change. I'd start with coding the basic conversion based on time zones - some world maps include that information - then use Google to search out areas that don't observe the change with seasons and add them to a list of excluded regions. You may also have to account for differing dates for the time change. It may be possible, and definitely worth the time spent searching for it, to find a freely available script on the web that someone has already invested the time and research into creating.
If you do end up coding your own, it would make a very nice article for CP - I'd love to see it. Good luck!
Heard in Bullhead City - "You haven't lost your girl -
you've just lost your turn..." [sigh] So true...
|
|
|
|
|
Hi all.
I'm having a problem: I want to be able to display small texts to help the user of my web page to fill out a form. Acronym seemed to be exactly what I needed (or ToolTip in asp.net, looks like it works the same way), only it turns out that when I open the page in Netscape 7.1 the text is cut of after the 30 (or so) first letters, followed by "...". How can I force Netscape to display the whole text?
Thanks
/EnkelIk
|
|
|
|
|
If have 2 domains on totally sperate servers and I have a client request that I pass cookies from one server to the next. I've told him I don't think it's technically possible and in fact would cause insecurities. (I believe there was a bug in IE 4 or 5 which web sites could extract cookie info from other wbsites and possibly pull passwords from cookies).
He insists it's been done before (even though i'm the programmer) and that his competition is doing it.
His situtation goes like this:
Visitor comes to his site (his site generate a GUID and store it in cookie) but then they get redirected to another site, and that site needs the ability to now read the cookies just generated by the previous visit to the other site.
Anyone have any ideas???
Thanks
The word of the day is legs, let's go back to my house and spread the word
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
