Monday, 15 March 2010

Connect to web service in MS Access with VBA -


Is it possible to connect to a web service via VBA (for example, send an HTTP request) Microsoft Access? For example, if a user clicks on a button on a button, an HTTP request is sent to a web service that responds with OK .

Has anyone done this before?

Note: VBA, not VB.NET.

This code I have used quite successfully with Access 2003 It is from the interwab, copied and re-copied age first. It creates one, sends an HTTP GET request, and returns the result as a string. XMLHTTP = CreateObject ("MSXML2.XMLHTTP") XMLHTTP as a public function http_Resp (ByVal sReq as String) as a string dim byteData () object set as a byte dim XMLHTTP. Open "GET", sReq, False XMLHTTP.send byteData = XMLHTTP.responseBody Set XMLHTTP = None http_Resp = StrConv (byte data, vbUnicode) termination function

sReq URL; Function Responds You may need to ensure that ActiveX Data Objects are enabled under your reference (in the VBA editor, go to Tools> References).

Posted by at No comments:

Pass polymorphic type as argument in SoapUI when using ServiceKnownType in WCF Service -


I have a WCF service; There is an operation in this service, which receives the type of logic request . This is the only base type, and while calling the operation, we actually send the value of Request_V1 (which is inherited from request ) on which the full implementation of the request I want to send i

When trying to test the service of using soap, I am able to create complex type variant Request_V1 (by adding proper namespace) , But for some reason, the service is getting value such as it request type.

Reading about the service , I found out that I must clearly specify this succession in the client

Thanks

You must also specify the type in the SOAP message. For example 

  & lt; Request I: type = "d: RequestV1" & gt;   
 ...   
 Where I am defined as XML-instance namespace
Posted by at No comments:

sql - Simple Where Exists vs. In -


I can not see what I'm missing for my life but someone can tell me why the query that first I do not want to, but the second thing works fine? I know that the questions are not exactly the same, but they should return the same 20 rows and they do not do that. (Query fill the top 20 most common items in a table) 

  Choose rx.drug_class different from Rx where exists (Select the top 20 rx2.drug_class, COUNT (separate rx2.pat_id) Calculate , More than rank (), according to the order (different-pat_id), RX as RX Rx 2 - when the line given below is commented - this subquery gives the correct answer where rx .drug_class = rx2.drug_class group rx2.drug_class)   
 this works fine  
  choose rx.drug_class different from RX where In the rx.drug_class (select the top 20 rx.drug_class from the Rx group) 
   
 Where the subdivision present in the novel is not working, what gives?  
  
 
 
 However, if you are specifying a line number for the first query, you still have to  ORDER BY  This line number is required:  
  where rx.drug_class = rx2.drug_class group rx2.drug_class order by rn   
 Als o I am assuming that this is just a simplified example, because the following will be as good as the following:  
  Select the top 20 from RX group from RX group. Specific   
 Edit:  
 Your  EXISTS  will also not work because you are limiting their limitations in the internal before Before you count your ..., set the line in the external set to  SELECT  then in that case the line will always be present in the  top 20  count.  
  IN  works because it is a set of calculations for all rows ...  EXISTS  fails because every individual line in the external set Is being counted for .. Therefore, every line in the outer set is in the top 20 digits, when those numbers are limited to only the external line's  drug_class .   

 








Posted by



at





No comments:

containers - When will Docker be launched? -


I need a tool to finish the odd payload in standard containers, and give them a strong guarantee of isolation and duplication Running on any server with.

When will the dock be launched ??

It has been launched a few minutes ago!

You can reach the team at IRC # Dockkor @ Ferro.

Posted by at No comments:

c++ - Call child virtual function from parent -


Please help me I am not really good at polarity, I have classes inherited from other classes.

EDIT: Sorry, completely my mistake Even I have spent about 2 hours to find the problem. People who are interested (thanks for all help) 

  if (type.compare ("TEST1") == 0) Results = New Test (id, database); If (type.compare ("TEST2") == 0) Results = New Test (ID, Database); If (type.compare ("TOR") == 0) results = new tow (id, database);   
 "== 0" was completely unavailable.  
  class A {public: go to zero (do);} virtual zero () {printf ('a');}} class b: public A {virtual zeros ( (Printf ('B');}} int main {A * obj = new B (); obj- & gt; Go ();}   
 Result 'A' No '   
 
 
 After that I make it 'b' How can I manage? I covered some things to compile it:  
  #include & lt; stdio.h & gt; class A {public: virtual zero DO) { Printf ("a");} zero go () {DO ();}}; Class B: Public A {virtual zero DO () {printf ("B");}}}; int main () {A * obj = new B (); obj-> Go (); Return 0;} < / Code>  
 ( do  is a keyword;  printf  does not require char,  main  brackets, And gives an integer)  
 This has ever produced  B  for me regardless of the optimization level:  
  $ G + + heirs CPP-O beer end & amp; ./inherit b $ g ++ inherit.cpp -O1 -o war & amp; ./inherit b $ g ++ inherit.cpp -O2 -o war & amp; ./ Inherit B $ G ++ Beerius CPP-O3-O Bear End End; ./inherit b $ g ++ inherit.cpp -O4 -o war & amp; ./inherit b $ g ++ inherit.cpp -O5 -o war & amp; However, it is possible that you have filed a case of edge in your compiler, which has to go to  do ()  inside  ()   
 .   

 








Posted by



at





No comments:

.net - Waveform Analysis in C# -


I am working on a research project that includes wave analysis of bird call. Basically what needs to happen is that we will identify the 'Baseline' bird call audio files that represent specific types of calls, and then compare those collected samples with those basic files, to determine whether This is a match for a specific type of call. Since our team members are doing this manually, so it is incredibly time consuming, I think we can automate this process, but I'm not sure that the best place to start. I have seen some articles discussing FFT, NI has seen Measurement Studios (very expensive for the enterprise version) and some other thread, but nothing seems to hide as a viable solution.

Did something like this in C #? Is there an underlying library for .NET for wave analysis? Am I stumbling in acoustic fingerprinting with this idea?

Any help is appreciated.

I do not know about any libraries that you are actually doing after that. Maybe a math library is enough with the necessary features? If so, I have used FFT capabilities very successfully in the past.

Posted by at No comments:

Auto-generate JPA XML mappings from clean Java classes / POJOs using library/tool -


I am currently working for a customer who developed many clean, non-annotated Java POJO domain models. Each domain model has approximately 15-50 classes. So far, these Java Pojo domain models are only used in Android apps. My clients are undertaking a new project, it is necessary to use these domain model server side, and it is necessary to save the examples of your classes in a SQL database.

We will use JPA for this. Since the jar needs to be reused in the current Android app, using JPA annotations is not an option. Therefore, I have to make JPA XML mapping for these 100+ sections.

I was wondering: Can JPA XML Mapping using some lib / tools generate XML mapping from clean Java classes / POJO? When I started looking up, I thought I was getting "Jahomodel 2 JPAP XML Mapping" tool very quickly, but so far, there was no luck, and I was only looking a while ago.

For me, it seems that a device that will be useful in many scenarios, so I can not believe that it is not in existence.

I know that equipment like HBM2 Java, I know that it is possible to make POOOS / ORM mapping from DDL and POJOS / DDL with an ONR Mapping. But I need Om mapping which has been given to POOs.

In addition to this, I know that JPA XML Mapping can automatically map very little and simple / original properties. I know that I will not have to map every single property, but still, if I do not find such a tool, then I have to face the repetitive work.

So, there is a "Javmoldel 2 JPA XML Mapping" tool?

Maybe stupid idea but how about the back / proxy about back generators. Files with JPA JPA @ Annotation Tag Big show stops may be that your app should use the JPAC customer type, which is not real. Just one suggestion does not kill the Messenger. 

  @Entity @Table (name = "customer") public class increases the JPC customer customer {@Id @ generatedValue (strategy = GenerationType.INDNTITY) public long GetId () {return super. GetId (); } Public Zero Set ID (Long ID) {Super .setId (ID); } @column (name = "name") public string getName () {return super.getName (); } Public Zero Setname (strings) {super.setName (s); } // ElementClonen offers simple EkTam linking in OpenJPa. // Insert column.name = @ElementCollection (fetch = FetchType.LAZY) @CollectionTable (name = "cust_role", joinColumn = {@ JoinColumn (name = "cust_id")}) @ column in the hair table (name = "role ") Public listing & lt; String & gt; GetRoles () {return super.getRoles (); } Public Zero centrum (list & lt; string & gt; roles) {super.setRoles (roles); } ...}
Posted by at No comments:
Subscribe to: Posts (Atom)