labmonkey111
Last Activity: Mar 17 '12, 01:18 AM
Joined: Sep 22 '08
Location:
-
I eventually started thinking that using the After Update event might work, at least for the form side of things. Which for my purpose would be adequate, since I'm only concerned about the user's experience. I can manually run an UPDATE statement if I need to. But since this was a project for my job, I didn't want to spend any more time on it than was necessary, so I just went the way of allowing nulls. Maybe I'll try the After Update solution next... -
How to make access use empty string instead of NULL
I have a table in SQLServer with a varchar field set to NOT NULL, with a default value of the empty string. This table is linked in access, and the field is linked to a text box on a form. When I attempt to edit that field, all is good unless I need to delete everything in the text box and return it to the default state of the empty string, Access complains: "You tried to assign the NULL value to a variable that is not a variant data type".... -
To get the file to run through php, you will need to access it like this:
http://localhost/hello.php
Otherwise your browser is trying to open the raw php source, and not php's output....Leave a comment:
-
This is a good place to start, especially the part about submitting your site.
http://www.google.com/support/webmas...y?answer=35769...Leave a comment:
-
Including the X-Mailer and Message-ID headers can also help in avoiding getting tagged as spam. I had the same problem, drove me nuts until I figured this out.Leave a comment:
-
Try:
This will tell the browser to go to the specified page.Code:header("Location: home.php"); exit;Leave a comment:
-
In GROUP_CONCAT() you can put any expression you want, so you should be able to do something like this:
...Code:SELECT w.wine_id AS wineId, w.name AS wineName, GROUP_CONCAT([B]CONCAT(g.name,' ',wtg.percentage)[/B]) AS grapeId FROM WineToGrape AS wtg INNER JOIN Wine AS w ON (wtg.wine_id = w.wine_id) INNER JOIN Grape AS g ON (wtg.grape_id = g.grape_id);Leave a comment:
-
The if-statement on line 25 is missing curly braces, the scope you seem to intend to have based on your indentation is not the way php will see it. As it is written, the only way you will have no output is if the first if statement evaluates to false, I would put an else for that statement to see if that is the case. A couple of other problems I see is you are not safeguarding again a mysql injection attack (run all user input through mysql_real_esca pe_string()),...Leave a comment:
-
Many things could cause the email not to send, or appear not to send. Are you getting any errors? Does it say its send its but you don't get the email? In anything in the error logs?
A few problems I had when first using the mail() function was that php.ini needed to use the full path to sendmail, the message text needs each line to be less than 70 characters long, and of course, my spam filter kicked it every time. Giving more detail...Leave a comment:
-
If all you need is to show the data, and not have any interaction, I'm fairly certain you can do something like File > Save as Web Page..., or something similar, from within excel and it will create the HTML for you. Of course, if the data changes very often, this can get tedious really fast, and you would need to come with some kind of automated/programmed solution.Leave a comment:
-
Personally, I think the best way to deal with this is to open the external sites in a new window or tab (by using 'target="_blank "'). The users get to view at the correct size, and when they close the external site, they come right back to the originating window, so they don't really leave the original site, not for very long at least.Leave a comment:
-
Almost what I want, but it won't overwrite the existing forms, just tacks a "1" at the end of the name. The options button didn't reveal any overwrite options. Any other suggestions? I'm using Access 2000.
Edit: Make that Access 2002, the DB is in 2000 format.Leave a comment:
-
Bulk Copy of forms/queries From one Access DB to Another
The company I work for uses a very large program in Access/VBA. Whenever I edit it, I copy the latest edition to my harddrive and make the necessary changes, then copy the modified forms/queries/reports back to a central copy where we all merge our changes. The problem I am having is that this program is very, very large (WAY beyond the scope of what VBA was ever intended for I'm sure). I repeatedly find myself coping a hundred or more files into... -
This was just a template that the site uses so the eCommerce page will look the same as the real site. After fighting with it for hours and fixing tons of other bugs and display issues, I did manage to find out that I was using the wrong doctype. The first person to work on this project used Dreamweaver and apparently it guessed wrong. The original template had no doctype, so as soon as I removed it altogether it worked ok. I hate not using one but...Leave a comment:
-
You can use different classes to style the links differently. Define your css like this:
...Code:a.link1:link{ ... styles here ...} a.link1:visited{ ... styles here ...} a.link1:hover{ ... styles here ...} a.link1:active{ ... styles here ...} a.link2:link{ ... styles here ...} a.link2:visited{ ... styles here ...} a.link2:hover{ ... styles here ...} a.link2:active{ ... stylesLeave a comment:
-
As I said, I have no control over this code, it is inserted by the e-commerce site into the template I'm designing. I'm well aware that the code sucks, but I can't do anything about it.Leave a comment:
-
FireFox <script> tag bug
I'm having trouble with the following code:
...Code:<SCRIPT> <!-- if (navigator.appName == 'Microsoft Internet Explorer') { document.write("<link rel=\"stylesheet\" type=\"text/css\" href=\"templates/94076/menu.css\" media=\"screen, print\" />"); document.write("<script src=\"templates/94076/menu.js\" language=\"javascript\" -
There are two ways you can fix this problem. The best way is to enclose the data in quotes as you mentioned, so if you have someone put in a name like John Doe, Jr. you store it as "John Doe, Jr." so the extra comma won't break anything. This should be a simple matter of adding quotes in the string you are writing to the file, just be sure to escape the quotes, maybe something like this:
...Code:$str_to_file = "\""
Leave a comment:
-
Gave it a try, and surprisingly that didn't even do it. Oh, well, its not really a high priority to get it to behave like that anyway, just thought it be a little more user friendly. I may come back to it after the site is closer to being completed. Thanks for the suggestion.Leave a comment:
-
I've had problems in IE7 before with the a page loading completely wrong the first time. Then I hit refresh and it'd be all ok. It only happened about one in ten times (made any debugging attempts a pain). Never did figure out why. I've also seen the opposite, it loads right the first time, but if you hit refresh, it'd be all messed up. I'd say its just a sporadic IE bug and there isn't much you can do about it.Leave a comment:
No activity results to display
Leave a comment: