|
I'm working on a script for my employer's website that will take form data and enter it into a MySQL database. Easy enough...until they wanted it to never have any gaps in the "id" field. They want the "id" field to be automatically generated and for it to never have any gaps in it if we decide to delete someone out of the database for whatever reason. To do this I wrote the following code (this isn't in it's entirety, just the pieces that are pertinent.)
$id = 0;<br />
$query = mysql_query("SELECT * FROM <tablename> ORDER BY id") or die(mysql_error());<br />
$row = mysql_fetch_array($query) or die(mysql_error());<br />
<br />
<br />
while( $row['id'] = ($id + 1)){<br />
$id += 1;<br />
}<br />
$id +=1;</tablename>
It looks to me that it should say "while the id field (1) = $id + 1 (1) then add 1 to $id and repeat until the id field doesn't = $id + 1 anymore." For some reason though, when I run the script from the website it just sits there until I get this error back from Firefox.
Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/www.website.com/htdocs/script.php on line 33
If I take the while statement out of the code and just have it echo back the values of $row['id'] and $id + 1 it brings back 1 and 1. But if I add the while loop in there it errors out again. I've tried while, do while, and if statements all to no avail.
My apologies for the lengthiness, but I wasn't sure how to make this more concise.
|
|
|
|
|
while( $row['id'] = ($id + 1)){
don't you think that you are using ASSIGNMENT operator instead of EQUALITY COMPARISON operator i.e. = instead of ==
Ashish Sehajpal
|
|
|
|
|
Ah...wow I feel dumb. Yeah that was the problem...the script works beautifully now. I guess I skipped that chapter when I was teaching myself PHP.
Thanks!
|
|
|
|
|
Hello,
I am posting string data from C++ application, which uses activex webbrowser control, to ASP. The only way i can post this string in binary using safearray.
Anyhow, I am able to successfully read this string in ASP server and assign it to client script varible using following statement.
inputstr = "<%Response.BinaryWrite(Request.BinaryRead(Request.TotalBytes))%>"
The problem is when i have some special characters like ",\r,\n... in my string.
Is there a way to get this string to client sdie, so that i parse it and populate fields.
Thanks
|
|
|
|
|
have u tried html encoding?
Ashish Sehajpal
|
|
|
|
|
I tried Html encoding, and having same problem.
I tried with simple \n in the input string:
function DisPlayMsg()
{
var outputstr
outputstr = "<%= Server.HTMLEncode(Response.BinaryWrite(Request.BinaryRead(Request.TotalBytes))) %>"
alert(outputstr)
}
And after server process:
function DisPlayMsg()
{
var outputstr
outputstr = "abcd
efgh"
alert(outputstr)
}
Ann obviously it is erroring out.
|
|
|
|
|
Ok, the Server is VBScript and the ClientSide is javascript
so, you need to replace Chr(13) with "\r" and Chr(10) with "\n" VB wonnt encode these characters
Giving you:
function DisPlayMsg()
{
var outputstr
outputstr = "abcd\r\nefgh"
alert(outputstr)
}
Its a been a while since I have used ASP, but I dont get while you are calling Response.BinaryWrite. The response is the output of the ASP page which I gather is the above code, so I don't see why your calling Response.BinaryWrite?
EDIT
I see why you are calling BinaryWrite, your first post does not use the <%=%> method of writing out the value. try converting the BinaryRead output to a string and running a replace on it.
James
James Simpson
Web Developer
imebgo@hotmail.com
P S - This is what part of the alphabet would look like if Q and R were eliminated
Mitch Hedberg
modified on Thursday, May 8, 2008 10:42 AM
|
|
|
|
|
James Simpson wrote: Its a been a while since I have used ASP, but I dont get while you are calling Response.BinaryWrite. The response is the output of the ASP page which I gather is the above code, so I don't see why your calling Response.BinaryWrite?
Hello,
I am kind of new to ASP. so I was trying to different ways to extract string.
I tried the replace, but same result(error).
<%Dim Binary11<br />
Binary11 = Request.BinaryRead(Request.TotalBytes)<br />
Dim I, S<br />
For I = 1 To LenB(Binary11)<br />
S = S & Chr(AscB(MidB(Binary11, I, 1)))<br />
Next<br />
<br />
Replace S,"\r",Chr(13)<br />
Replace S,"\n",Chr(10)<br />
%><br />
<br />
outputstr = "<%= Server.HTMLEncode(S) %>"
|
|
|
|
|
Try:
S = Replace(S,Chr(13),"\r")
S = Replace(S,Chr(10),"\n")
I think you need to assign the return value of replace, and the parameters are the other way around (maybe??)
James
James Simpson
Web Developer
imebgo@hotmail.com
P S - This is what part of the alphabet would look like if Q and R were eliminated
Mitch Hedberg
|
|
|
|
|
Thanks James. Your replacement suggestion is working good. Only thing I have to solve now is handling '\' literal. If I have '\' in my string, it is missing when I assign it from server vbscript to cleint javascript. I tried replacing \ with \\, but no use.
|
|
|
|
|
HI
Is there any way we can hide the status bar of IE 7 programatically in javascript or in code behnind file of ASP.NET, not by setting the browsers setting manually from internet options in browsers, kindly reply ASAP, thankx in advance.
|
|
|
|
|
|
Dear web-programers:
i'm new in the code project site. I have been looking like crazy a script to upload images and add it to a form in my site.
The site I'm creating is for artists to sell their crafts online. I'm using the yahoo site builder to create the complete site.
I need this html/java script code to be added to a form. The script must be simple and to add an item / upload the image to the form. I will also like to have the option in the script that the image can be thumbnailed/enlarged. Once the form is completed and submitted by the artit, I need this image to appear and be re-directed in an specific page in the site.
So, I also need the script to have the option to be changeable by me. This way I can write in each form the artist gallery pages to re-direct the images to their galleries.
Maybe is an old fashion way to do it, but I need it to be simple for the moment. Maybe in the future I will go to an asp.net and a more dinamic way.
Please, help me! Or tell me where I can find this script.
Thanks,  ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif) MaryG
|
|
|
|
|
<input type="file /> will let you upload any file. How you process it on the server, is up to you.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
|
I love seeing the same posts here and on MSDN.
Like I said on MSDN, you need to do your own work, that is why they pay you.
Also, what does this have to do with web development ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Greetings,
Currently I'am working on a webpage
I want a treeview on a webpage with a context menu.
Is this possible; if yes, please provide me with a code example.
Thanks for every suggestion.
Peter
modified on Saturday, May 10, 2008 5:02 AM
|
|
|
|
|
It seems like your requirement is very much similar to an ASP Menu control. With Framework 2.0 it comes as a built in control.
If you want tree view itself then you have to create a div that appears on mouseover of each tree node and dissappears on mouseout.
|
|
|
|
|
hai all,
sorry to post this question here.i dont find a special forum for this ...thats why i am posting this ques here.I am new to DNN .. while creating report module i am getting this error.
Error: UserReports is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Unable to cast object of type 'ASP.desktopmodules_userreports_viewuserreports_ascx' to type 'DotNetNuke.Entities.Modules.PortalModuleBase'. ---> System.InvalidCastException: Unable to cast object of type 'ASP.desktopmodules_userreports_viewuserreports_ascx' to type 'DotNetNuke.Entities.Modules.PortalModuleBase'. at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings) --- End of inner exception stack trace ---
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
Inherit DotNetNuke.Entities.Modules.PortalModuleBase in your user control class.
Everything Is Possible!
|
|
|
|
|
Hi,
A new security feature of IE7 adds a statusbar to all dialogs in our web application, and this unfortunately ruins the layout of these dialogs. Is it possible to disable this feature, atleast for trusted applications????
I really hope someone can help.
Regards,
Thomas Lykke Petersen (MCP)
|
|
|
|
|
http://msdn.microsoft.com/en-us/library/ms537184(VS.85).aspx[^]
Window Restrictions - (FEATURE_WINDOW_RESTRICTIONS)- This control forces pop-up windows to remain in the viewable desktop area, display a status bar, and not draw their borders outside the viewable area of the screen. It ensures that browser windows cannot overlay important information in their parent windows, or in system dialogs. If enabled, windows may be restricted, depending on the URL Action for the page.
led mike
|
|
|
|
|
Is there any way we can hide the status bar of IE 7 programatically in javascript or in code behnind file of ASP.NET, not by setting the browsers setting manually from internet options in browsers, kindly reply ASAP, thankx in advance.
|
|
|
|
|
King Shez wrote: Is there any way we can hide the status bar of IE 7 programatically in javascript or in code behnind file of ASP.NET
in code behind? Are you kidding me? And no, javascript in the browser does not have access to the Registry. That would be a giant security hole now wouldn't it?
led mike
|
|
|
|
|
I am well aware of the fact that it is a new "security feature" but is there any possible way to disable it?
Regards,
Thomas Lykke Petersen (MCP)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
