顯示問題標籤 顯示所有問題
  • 被鎖定

I get a blank page on FB when I try to go there on my PC but no problem on my android smart phone

When I click on the FB icon it goes to my page but it is blank. I can go there on my android smart phone without a problem duplicated. continue at https://support.mozilla… (閱讀更多)

When I click on the FB icon it goes to my page but it is blank. I can go there on my android smart phone without a problem

duplicated. continue at https://support.mozilla.org/en-US/questions/1283094

Asked by 8balllee 2 個月前

  • 被鎖定

i have problem whith google keep site

i have one note from google keep site, which work very very slowly, but google chrome no problem... Замена товаров в операциях UPDATE Operations SET GoodID=292 WHERE Good… (閱讀更多)

i have one note from google keep site, which work very very slowly, but google chrome no problem...

Замена товаров в операциях UPDATE Operations SET GoodID=292 WHERE GoodID=251

дубли товаров по алкокоду (каталог 2) SELECT * FROM Goods WHERE Catalog2 In (SELECT Catalog2 FROM Goods WHERE Catalog2 <> AND ID > 1 GROUP BY Catalog2 HAVING COUNT(Catalog2) > 1) ORDER BY Catalog2

дубли партнеров по ФСРАР id (карта) SELECT * FROM partners WHERE CardNumber In (SELECT CardNumber FROM Partners WHERE CardNumber <> AND ID > 1 GROUP BY CardNumber HAVING COUNT(CardNumber) > 1) ORDER BY CardNumber

дубли считанных марок (mssql) SELECT * FROM InternalLog WHERE Message In (SELECT Message FROM InternalLog WHERE Message like '%UTM_%' GROUP BY Message HAVING COUNT(Message ) > 1)

дубли считанных марок (access) SELECT * FROM InternalLog WHERE CStr(Message) LIKE '%UTM_%' AND CStr(Message) In (SELECT CStr(Message) FROM InternalLog WHERE CStr(Message) <> GROUP BY CStr(Message) HAVING COUNT(CStr(Message)) > 1)

Замена товаров в операциях UPDATE Operations SET GoodID='ИД товара который нужно оставить' WHERE GoodID='ИД товара который убираем'

выбор только пивной продукции Select * From goods where Ltrim(Rtrim(substring(goods.catalog3, 178, 15))) in (261,262,263,500,510,520)

select * from goodsgroups where code like 'aab%'

SELECT * FROM Goods WHERE Catalog2 In (SELECT Catalog2 FROM Goods WHERE Catalog2 <> AND ID > 1 GROUP BY Catalog2 HAVING COUNT(Catalog2) > 1) ORDER BY Catalog2

SELECT * FROM Goods WHERE IsNumeric(Barcode1)=0 AND Barcode1<> SELECT * FROM Goods WHERE IsNumeric(Code)=0 AND Code<>

update operations set userrealtime = userrealtime -1 WHERE...

update operations set userrealtime = date + convert(nvarchar(8),userrealtime,114) WHERE ...

А что может быть проще? Insert [ИМЯ НОВОЙ БАЗЫ].[dbo].[partners] ([Code],[Company],[Company2],[MOL],[MOL2],[City],[City2],[Address],[Address2],[Phone],[Phone2],[Fax],[eMail],[TaxNo],[Bulstat],[BankName],[BankCode],[BankAcct],[BankVATName],[BankVATCode],[BankVATAcct],[PriceGroup],[Discount],[Type],[IsVeryUsed],[UserID],[GroupID],[UserRealTime],[Deleted],[CardNumber],[Note1],[Note2],[PaymentDays]) (Select [Code],[Company],[Company2],[MOL],[MOL2],[City],[City2],[Address],[Address2],[Phone],[Phone2],[Fax],[eMail],[TaxNo],[Bulstat],[BankName],[BankCode],[BankAcct],[BankVATName],[BankVATCode],[BankVATAcct],[PriceGroup],[Discount],[Type],[IsVeryUsed],[UserID],[GroupID],[UserRealTime],[Deleted],[CardNumber],[Note1],[Note2],[PaymentDays] from [ИМЯ СТАРОЙ БАЗЫ].[dbo].[Partners])

Server1 - 1000-2499.99 => 4% UPDATE p SET Discount = 4 FROM partners AS p INNER JOIN

   (
       SELECT PartnerID, SUM(Qtty*Sign) AS TurnoverSum
       FROM payments
       WHERE [Mode] = 1
       GROUP BY PartnerID
   ) paym
   ON p.ID = paym.PartnerID

WHERE paym.TurnoverSum >= 1000 AND paym.TurnoverSum < 2500

Server2 - 2500+ => 5% UPDATE p SET Discount = 5 FROM partners AS p INNER JOIN

   (
       SELECT PartnerID, SUM(Qtty*Sign) AS TurnoverSum
       FROM payments
       WHERE [Mode] = 1
       GROUP BY PartnerID
   ) paym
   ON p.ID = paym.PartnerID

WHERE paym.TurnoverSum >= 2500


разные цены

Select * from operations o2 where goodid in (select distinct goodid from operations o left join goods g2 on g2.id = o.goodid where o.Priceout <> g2.priceout2) SELECT * FROM partners WHERE TaxNo = AND CardNumber not like '%050000%' AND CardNumber <>


Александр, вот триггер: USE [vd3] GO /***** Object: Trigger [dbo].[PaymentTypesByUsers] Script Date: 08/14/2017 07:36:40 *****/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create Trigger [dbo].[PaymentTypesByUsers] ON [dbo].[Payments] AFTER INSERT

AS

IF (SELECT OperType from inserted) = 2 and (SELECT Type from inserted) = 6 and not (select pg.code from inserted left join partners p on inserted.PartnerID=p.id left join PartnersGroups pg on p.groupid=pg.id) like 'AAA%' begin raiserror 100001 'ЗапрещПродажа_Lesop' ROLLBACK TRANSACTION RETURN end IF (SELECT OperType from inserted) = 2 and (SELECT Type from inserted) in (1,2,3,4,5) and (select pg.code from inserted left join partners p on inserted.PartnerID=p.id left join PartnersGroups pg on p.groupid=pg.id) like 'AAA%' begin raiserror 100001 'ЗапрещПродажа_Lesop' ROLLBACK TRANSACTION RETURN end

триггер в Payments на запрет видов оплаты в зависимости от партнера


DELETE FROM ApplicationLog DELETE FROM CashBook DELETE FROM CurrenciesHistory DELETE FROM Documents DELETE FROM ECRReceipts DELETE FROM InternalLog DELETE FROM Lots where id > 1 DELETE FROM Network DELETE FROM NextAcct DELETE FROM Operations Where OperType NOT IN (20,21) DELETE FROM Payments DELETE FROM Transformations DELETE FROM Store

Эту выполнять после всех. DELETE FROM Goods WHERE ID NOT IN (SELECT DISTINCT GoodID FROM Operations)

UPDATE Partners SET Phone2=Phone WHERE NOT Phone=Phone2 AND ID>1 В шедулер

операции без товара: select goodid from operations where goodid > 0 and goodid not in (select distinct id from goods)

DECLARE @CashbookID as int DECLARE @ObjectID as int DECLARE @Acct as int DECLARE Acct_Cursor CURSOR local FOR SELECT ID FROM cashbook where SUBSTRING([Desc],13,10) IN (SELECT DISTINCT Acct FROM payments where opertype = 2) OPEN Acct_Cursor

FETCH NEXT FROM Acct_Cursor into @CashbookID
WHILE @@FETCH_STATUS = 0 
IF @@FETCH_STATUS = 0 
BEGIN
 SET @Acct = (SELECT SUBSTRING([Desc],13,10) FROM cashbook WHERE ID = @CashbookID)
 SET @ObjectID = (SELECT TOP(1) ObjectID FROM payments WHERE acct = @Acct)
 UPDATE cashbook SET ObjectID = @ObjectID WHERE ID = @CashbookID
 FETCH NEXT FROM Acct_Cursor into @CashbookID;
END
ELSE 
 CLOSE Acct_Cursor
 DEALLOCATE Acct_Cursor

Привет! Подскажите пожалуйста, как поправить таблицу CashBook, поле ObjectID? Нужно привести в соответствии с таблицей Operations или Payments. БД MSSQL 2012



дата из примечания

обновит все строки, где в примечании есть слово ЕГАИС

MSSQL:

update operations set date = cast(convert(datetime, SUBSTRING(Note, 7, 10), 104) as date) where note like 'ЕГАИС%' and opertype = 1

ACCESS:

________________

it isn't all

v.s. -->

Asked by 5978156 1 個月前

  • 被鎖定
  • 封存

Why was thread http://support.mozilla.org/en-US/questions/936004?page=4 closed without being addressed or resolved?

Hi As of Firefox 20, this issue is STILL unaddressed and unresolved. Why won't ANYONE at mozilla support PLEASE tell us what the story is... with Firefox switching to or… (閱讀更多)

Hi As of Firefox 20, this issue is STILL unaddressed and unresolved. Why won't ANYONE at mozilla support PLEASE tell us what the story is... with Firefox switching to original window... when a site with flash elements... is "opened in a new window"? PLEASE? If there's a bickering match over "how things should be done" between flash folk and Firefox folk, TELL US! Closing the thread DOES NOT make the anomaly go away.

Asked by Wingy99 7 年前

Last reply by Wingy99 7 年前

  • 被鎖定
  • 封存

where do i go to check the age of a site and their SEO strength? Am i able to check the number and quality of links to their sites?

I would like to check the age of a site in an industry I am thinking of going into. I would like to check the strength of their on page SEO. I wold like to check the numb… (閱讀更多)

I would like to check the age of a site in an industry I am thinking of going into. I would like to check the strength of their on page SEO. I wold like to check the number of links they have on their site and the strength of those links.

Asked by keilhauer 7 年前

Last reply by user633449 7 年前

  • 被鎖定
  • 封存

question on finding age of website not found, its why i joined firfox.

Age of someones website? strength of SEO? number and quality of links? I signed up to find out the age of someones website, the others would be a bonus, Tyler your tellin… (閱讀更多)

Age of someones website? strength of SEO? number and quality of links? I signed up to find out the age of someones website, the others would be a bonus, Tyler your telling me firefox is not able to do this?

Asked by keilhauer 7 年前

Last reply by user633449 7 年前

  • 被鎖定
  • 封存

Firefox print garbage some arabic text.internet explorer print fine .i have windows xp with firefox 20.0.

locking as a duplicate of https://support.mozilla.org/en-US/questions/958046 Firefox print garbage some arabic text.internet explorer print fine .i have windows xp with f… (閱讀更多)

locking as a duplicate of https://support.mozilla.org/en-US/questions/958046

Firefox print garbage some arabic text.internet explorer print fine .i have windows xp with firefox 20.0.

Asked by babuchupring 7 年前

Last reply by iamjayakumars 7 年前

  • 被鎖定
  • 封存

When will you *************** that FF remains today?

MESSAGE FROM AN ACTUAL FF "SUPPORT" PAGE: "Oh! So, you want to offer us feedback on Firefox. Thank you, but you'll need to be on the latest version. To do that, simply g… (閱讀更多)

MESSAGE FROM AN ACTUAL FF "SUPPORT" PAGE:

"Oh! So, you want to offer us feedback on Firefox. Thank you, but you'll need to be on the latest version. To do that, simply go to our download page and install/update to the latest version of Firefox!"


MESSAGE FROM ME VIA IE:

deleted

Edited by a moderator due to language. See the Rules & Guidelines .

Asked by SupportDumbedDownByHoles 7 年前

Last reply by user633449 7 年前

  • 被鎖定
  • 封存

youtube search shows nothing

Duplicate please continue with /questions/960877 when my firefox automatically updated into v21 my youtube search shows nothing. <a href="http://s155.photobucket.com/u… (閱讀更多)

Duplicate please continue with /questions/960877 when my firefox automatically updated into v21 my youtube search shows nothing. <a href="http://s155.photobucket.com/user/prowse123/media/ff_zps44765e31.jpg.html" target="_blank">error photo ff_zps44765e31.jpg</a> i tried other browser so i knew it wasn't on my system, anyways i tried doing it in safe mode and clearing all cache but still no luck can anyone help?

Asked by prowse123 7 年前

Last reply by John99 7 年前

  • 被鎖定
  • 封存

why do we pay higher prices online using Firefox?

I just read this interesting article and wondered what you think and if it's true? Should you pay more when you're shopping online simply because of the browser you're us… (閱讀更多)

I just read this interesting article and wondered what you think and if it's true?

Should you pay more when you're shopping online simply because of the browser you're using? Some popular online retailers think so!

The New York Times reports shoppers are getting widely different prices based on whether they use Chrome, Firefox, Internet Explorer, or Safari. Here are just two examples:

   For the same Samsung TV on NewEgg.com, a Chrome user was offered a price of $997. Meanwhile, the price was $1,399 when using Firefox or Internet Explorer.
   Another Samsung television model at Walmart.com was offered for $199 on Firefox and $168 on Chrome and Internet Explorer.

Meanwhile, Mac users could be paying a higher rate for hotel rooms on Orbitz.

According to The Wall Street Journal, Orbitz has been experimenting with a 30% premium on Mac users when they search for select hotel rooms versus PC users. That effectively works out to be around $20 to $30 more than a PC user.

When asked for explanation, Orbitz basically stated that Mac users make more money and are interested in fancier hotels. (There were no happy campers in the Apple world based on those comments!)

The best way for you to stay one step ahead of online retailers who are manipulating price is to use technology to fight back.

If you want an easy way to see if a quoted price is a deal or not, you can compare prices on websites like Decide.com or ShopoBot.com, or use a browser bookmarklet such as Hukkster.

Another alternative would be to install a browser plug-in like Invisible Hand that automatically pops up an alert while you're shopping if a better price is available on another website.

Finally, Amazon customers can typically get a better deal if they put something in their cart and then abandon it before the final purchase. That usually signals to Amazon that you're willling to walk away and triggers a lower price the next time you put it in your cart to checkout. Give it a try!

Asked by wolfdad 6 年前

Last reply by user633449 6 年前

  • 被鎖定
  • 封存

ATItesting.com won't work anymore on my firefox

Locking duplicate thread. Please continue here: [/questions/964185] I use a site called atitesting.com for nursing school, as of about a week ago, i can't open up the pr… (閱讀更多)

Locking duplicate thread.
Please continue here: [/questions/964185]

I use a site called atitesting.com for nursing school, as of about a week ago, i can't open up the practice tests anymore. I works on my laptop, but no longer on my imac desktop. Any suggestions?

i basically just won't load anymore at all.

Asked by ehueck 6 年前

Last reply by kobe 6 年前

  • 被鎖定
  • 封存

I can't get into search engines - says the site isn't found for both Yahoo & Google.

I got a response telling me how to set a search engine as default. That is not what I asked. I try to go to either Yahoo.com or Google.ca and get told "error 404 - this… (閱讀更多)

I got a response telling me how to set a search engine as default. That is not what I asked. I try to go to either Yahoo.com or Google.ca and get told "error 404 - this is all we know" and it won't let me even access the page never mind setting it as default. Until I did the upgrade, I didn't have this problem. How do I fix this?

Asked by lynnettew99 6 年前

Last reply by cor-el 6 年前

  • 被鎖定
  • 封存

Every time iI try to open an extension from a web site I get two to three more unwanted advert sites from fire fox

Locking as duplicate. Please continue with /questions/968876 When in any web site but I will give ESPN F1 as an example it always shows four latest topics. When I click … (閱讀更多)

Locking as duplicate. Please continue with /questions/968876
When in any web site but I will give ESPN F1 as an example it always shows four latest topics. When I click on to any of these up pops another two to four new web sites advertizing all sorts of junk I don't want to know about including very regularly asking if i want a USA green card. How can I stop this. I've tried deleting Firefox and reinstalling but get the same result.

I've been using Fire Fox for well over ten years now both at home and at work where there were no such problems when i retired some four months back.

Can you please help.

Asked by drew.white 6 年前

Last reply by John99 6 年前

  • 已解決
  • 被鎖定
  • 封存

how to stop hotmail automatic log in

After I sign out of hotmail and try to sign in with a different username, Firefox automatically logs me in to the original hotmail. I have "remember pass words" unchecke… (閱讀更多)

After I sign out of hotmail and try to sign in with a different username, Firefox automatically logs me in to the original hotmail. I have "remember pass words" unchecked so it should not know my password. How do I fix this? With gmail and facebook, it brings up the log in page ok, but does not with hotmail.

Asked by martidvm 6 年前

Answered by ideato 6 年前

  • 被鎖定
  • 封存

Support contributor not allowed contibution

I am in the top 25 contributors list .My present rank is 19th. Recently after 100th post , an error message started occurring saying I have exceeded the maximum number of… (閱讀更多)

I am in the top 25 contributors list .My present rank is 19th. Recently after 100th post , an error message started occurring saying I have exceeded the maximum number of post in a given time .I don't know how this works , but please someone fix it for me , because I love helping out people.

Asked by SHASHANK ROY 6 年前

Last reply by the-edmeister 6 年前

  • 被鎖定
  • 封存

pool live tour was not start due to an error that you provide him a old information of me..... (error code:sec_error_ocsp_old_response)

Secure Connection Failed An error occurred during a connection to apps.geewa.com. The OCSP response contains out-of-date information. (Error code: sec_error_ocsp_old_resp… (閱讀更多)

Secure Connection Failed

An error occurred during a connection to apps.geewa.com. The OCSP response contains out-of-date information. (Error code: sec_error_ocsp_old_response)

   The page you are trying to view cannot be shown because the authenticity of the received data could not be verified.
   Please contact the website owners to inform them of this problem. Alternatively, use the command found in the help menu to report this broken site.

Asked by vikasrawat287 6 年前

Last reply by AliceWyman 6 年前

  • 被鎖定
  • 封存

How can I find my post?

your thread is here - https://support.mozilla.org/en-US/questions/974084?esab=a&s=&r=0&as=s - locking Earlier I asked a question amnd got an answer from Cor-E… (閱讀更多)

your thread is here - https://support.mozilla.org/en-US/questions/974084?esab=a&s=&r=0&as=s - locking

Earlier I asked a question amnd got an answer from Cor-El Now: my e-mail indicated that there was an answer to my question but where can I find it here? There was no direct link to my question and I cant find it anywhere else.

Maybe mozilla should use normal forums software like IPB because thats easier to handle.

Asked by eireann.vives 6 年前

Last reply by cor-el 6 年前

  • 被鎖定
  • 封存

Why am I getting "This page has moved. Click here for new location." messages?

Locking duplicate thread. Please continue here: [/questions/975289] I'm currently running v24 in Windows 7 Pro x64. Since one of this year's updates (21? 22? 23?), seve… (閱讀更多)

Locking duplicate thread.
Please continue here: [/questions/975289]

I'm currently running v24 in Windows 7 Pro x64.

Since one of this year's updates (21? 22? 23?), several web sites that I've been visiting weekly or monthly (to pay bills, etc.) for years no longer work smoothly. Clicking on links/buttons that execute actions (e.g., "Submit", "Next", etc.) don't go directly to the desired page. Instead I get a page with a text message that's something like "This page has moved. Click here for new location." (And no, they're not the "redirecting in 10 seconds" kind of messages.) I can still get to where I need to go by clicking that second link, but all those extra clicks in the past 2-3 months are getting on my nerves.

Needless to say, this is really annoying. Since I've not added any new add-ons in many moons, my suspicion is that Mozilla changed a default setting somewhere in a recent update (from "Off" to "On" or "True" to "False" or vice versa). Anyone have some insight into how I can eliminate this annoyance?

Asked by bethel95 6 年前

Last reply by bethel95 6 年前