First you simply set the target properly of your <a href> with
Code:
<a href="Default.aspx?title=WhateverYouWant" target"_blank">
jeffstl
Last Activity: Feb 3 '11, 04:07 PM
Joined: Feb 16 '08
Location:
-
Not sure I should answer this. There are plenty of ways to do this, if I understand what your saying correctly.
First you simply set the target properly of your <a href> with
Next, well you can either use session variables or just pass a query string if you want to dynamically change the new windows title. Once... -
If you really need multi-line you can also just check the total character count before you save it too (in code) using constants or some other validation if you want to stay away from javascript for whatever reason.
Since you have your max set to 20 though, I suspect you don't really need multiline ;)Leave a comment:
-
code green is correct. To clarify you need to check the actual column properties in the table MCVISITORS on the database.
If you have the power a quick fix would be to just increase the number of characters you can save in those columns ;)
But likely they were set for a reason, so a better option might be checking the length of the problem data before you pass it into your SQL, and if its too long then wherever that...Leave a comment:
-
Without getting into details the changes to the SP's were heavily involved in understanding the various units of measure things were stored in, and the various divisions of inventory based on the status of that inventory, and determining the total counts, demand, and allocation as part of a regular automated process, and funneling said inventory counts through a process to determine which divisions of the company would get what based on various pecking...Leave a comment:
-
My biggest issue is the lack of testing. The general response is that "I" should test it but my knowledge of the typical flow of some of these processes is limited at best, and some of these stored procedures are thousands of lines long performing demand calculation, inventory allocation, and dividing up inventory among various profit centers within the company.
I bring these up in particular because it was something I just...Leave a comment:
-
Is the workload that the company I work for gives me normal?
We are a staff of 3 IT people. 2 of us handle all internal operations, and 1 handles the www application.
We have end to end control from SQL Server 2008, Windows server, up to the .NET application that runs the entire company such as Sales, Marketing, HR, Finance, Order Processing, Inventory, Reports, etc.
We manage approximately 1550+ Stored procedures, easily 500 or so tables, and off shoot side applications as well.... -
Leave a comment:
-
Yeah. This one here:
select id,url,source,a mount from offers where price in (select min(price) from offers group by source)
That's just another way of doing what I was saying about defining what "cheap" means. That one above is selecting things from offers where price is equal to the minimum price of the entire table.
So if you did something like above you would get all products listed that were...Leave a comment:
-
Hmm. Could be. I am not that familiar with Access but I know it should work similar to VB6.0.
So it sounds like the variable is needed not only across functions but across modules?
Regardless it looks like in your post you still have the variable declared inside of a function. It has to be declared outside the function either at the top of the module or possibly in a different module all together (which at that point it...Leave a comment:
-
You need to make your varFileName variable be a Public Shared variable at the top of your module.
This will make it accessible across multiple functions in the same module. In other words, once you set it to a value....as long as the function you want to read that value is called AFTER it has been set...you can get it in there
...Code:'at the very top somewhere Public Shared varFileName as String
Leave a comment:
-
Hmm. Ok so you actually have groups of products that you want grouped up together by cheapest price.....
Thats a little more complicated and could involve more criteria or ranges of what "cheap" actually means.....
You could try defining your "cheap" range somehow and get all the products from each group by that range ....then order by Product
The below would get you exactly what you listed...Leave a comment:
-
Honestly I think your best bet is to have a check box or drop down that says "Order by" and have the option's be Cheapest price, or product. You can't really order by "both" with a single output table no matter what joins you use.......becau se if ZProduct is 1$ how can you put that at the bottom if you want cheapest at the top?
..so it goes to the top if you prioritize by Price. If there is a ZProduct for 1$ and a...Leave a comment:
-
Nooooot really. At least unless I am misunderstandin g what you are saying. The problem here is not limitations of programming or language, etc. But of the actual physical limitations of not being able to order things by 2 factors when 1 factors priority will always screw it up....
In other words, if AProduct's price is way more expensive then BProduct's price....and you order by Price as top priority...you HAVE to put BProduct first...Leave a comment:
-
In other words if product A is 10$ and Product B is 5$ Product B will be first and product A second in the Price priority.
In a alphabetic priority Product A will be first, Product B second, but then price becomes secondary in ordering.
So yeah you can't really have both as a top priority. Maybe you can look into passing a parameter that would distinguish which ordering the user wants (price or product).Leave a comment:
-
Well you have to have some kind of priority with the ordering.
Cheapest products first will list cheapest products first regardless of alphabetical order (but alphabetic will be a secondary ordering priority)
If you want alphabetic to be the highest priority then you just need to Order By ProductName, Price asc instead.
But you can't have both obviously. The ordering priority can only be one or the other.Leave a comment:
-
You'll want to look into the DateDiff function
http://www.vb6.us/tutorials/learn-ho...ediff-function...Leave a comment:
-
Try order by multiple things
SELECT * FROM PRODUCTS
GROUP BY PRODUCTNAME order by Price asc, PRODUCTNAME
The ASC is ascending, that will list price from cheapest to expensive, and the desc is descending which will list product alphabeticLeave a comment:
-
I am not sure exactly what you mean. If you mean you are wanting to do the city_From and to you just need to select those values out as well with the distance.
...Code:KM = "SELECT distance_KM,city_from,city_to FROM cities " _ & " WHERE city_from = '" & Replace( city_from, "'", "''" ) & "' " _ & " AND city_to = '" & Replace( city_to, "'",
Leave a comment:
-
Problems with crystal after sql server protocol encryption
After checking the box "Force Protocol Encryption" on SQL Server Network Utility there are several Crystal reports that begin to throw the following error when run
Query Engine Error: '08S01:[Microsoft][ODBC SQL Server Driver]Communication link failure'
Go back into the Server Network Utility and uncheck the Force Protocol Encryption and they work fine again.
Is there anyone that has encountered... -
select Distance_KM from distance where City_from = '" & txtCityFrom.Tex t & "' and City_To = '" & txtCityTo.Text & "'
That is the sql you want. You will need to set up a form with those names to accept criteria values.Leave a comment:
No activity results to display
Leave a comment: